How to output table variables back to caller?

[rmahawaii]

Hello, I have a local table variable @tableTmp in my stored procedures. How can I output the whole table variable back to the caller? thanks in advance.

 

[JamesLean]

Set the table variable as an output parameter rather than a local variable:

CREATE PROC myproc
  @input1 int,
  @input2 varchar(20),
  @tablevar table (col1 int, col2 varchar(10)) OUTPUT
AS
...

Populate the table as you are already doing in the proc code. Then when calling the proc use:

DECLARE @t1 table (col1 int, col2 varchar(10))
EXEC myproc 123, 'char data', @t1 OUTPUT

This will give you the built table from the proc in your variable @t1 --James