to get the resultset of sub sp and use it in main sp's

• damodharan-402092

  SSC Journeyman

  Points: 84

  More actions

  July 16, 2008 at 3:15 am

  #195291

  Hi.

  I want to get the result set of a sub sp's

  eg

  create proc test

  as

  begin

  select * from authors

  end

  exec test

  if i execute the above statement i will get the result set.

  in main sp i want to to get those resultset and to some calculation.

  can any one explain how can we do it.

• IN_Sandeep

  SSCertifiable

  Points: 6259

  More actions

  July 16, 2008 at 3:36 am

  #843633

  hi,

  why u need more sp, one sp is enough......:P

  you can simple use this..

  insert into #temp

  exec test

  Cheers!

  Sandy.

  --