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?
LVL 1
HLRosenbergerAsked:
Who is Participating?
 
BlueYonderCommented:
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'
0
 
HLRosenbergerAuthor Commented:
thanks.  that did the trick!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.