Proc calling Proc

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  May 18, 2007 at 4:09 am

  #120144

  I have a proc which is passing through a month and year parameter (based upon some table values) to another proc.

  The receiving proc ends in creating a final result set in a table variable. How do I return these figures in my calling proc?

  Thanks.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  May 18, 2007 at 4:54 am

  #707371

  I would create table function instead of second procedure.

  But if you insist on having SP do this:

  INSERT INTO #Resultset (... columns list ...)

  EXEC dbo.ReportSP (@Month, @Year)

  _____________
  Code for TallyGenerator