We help IT Professionals succeed at work.

Help with Stored Proc.  Returning records.

I have a stored proc that selects a set of record.    I read the data using a cursor, and set into DECLAREd variables.  I'm turning this set of records into a single record.   How do I return this single record/data?
Comment
Watch Question

You will have to store it into a temp table or another table

CREATE TABLE #tmpTbl
(
   COL1 INT,
   COL2 INT
)

INSERT INTO #tmpTbl
Exec yourproc Params'

Author

Commented:
thanks.  that did the trick!