Wednesday, May 23, 2007

How to get store procedure result set

This is the sql script to get other SP resultset in our store procedure:
 
CREATE PROC PROC_X
AS

CREATE TABLE #TmpTable( ... )

INSERT INTO #TmpTable EXEC usp_MySP @1, @2

No comments: