newbie question: how can i use result set returned by sp?..

• wep

  Grasshopper

  Points: 17

  More actions

  January 16, 2004 at 11:13 am

  #108658

  My stored proc A calls stored proc B. B returns a result set. How can i append B's result set to A's result set? I just can't figure out T-SQL syntax to do that. Reading BOL and SQL Server FAQ didn't help... any clues?

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  January 16, 2004 at 11:25 am

  #490499

  INSERT #TempTable

  EXEC ProcB

  
  
  --Jonathan

• ThomasH

  SSCertifiable

  Points: 7437

  More actions

  January 16, 2004 at 11:29 am

  #490500

  -- In SP A...

  Create Table Table1 .....

  -- From SP A

  INSERT INTO Table1 (col list)

  EXEC SP_B

  -- as long SP_B's has

  1 result

  
  
  Once you understand the BITs, all the pieces come together