CREATE PROCEDURE test_sproc_with_select_and_ops
(
	@output_number int     output,
	@output_text   varchar(10) output
)
AS
BEGIN
    select @output_number = 15
    select @output_text = 'results'

    select * from TEST_TABLE
END