Comments on: SQL SERVER 2005- How to call nested stored procedure and save the output in Temporary Table

By: mansoor

mansoor — Sat, 14 Nov 2009 19:02:07 +0000

If the 1st stored procedure is a union of 4 select statement.
Can i create an aggragate query out of the 1st-procedure without createing a temp table?

By: bhushan

bhushan — Tue, 10 Nov 2009 11:53:30 +0000

Hi,
I did same but when executing procedure sp_ FirstProcedure within sp_SecondProcedure, it is returning results but it is not inserting value in the temp table #tempCityEmp. Is there any settings need to be done? Please let me know ASAP.

Thanks,
Bhushan

By: Neil

Neil — Tue, 01 Sep 2009 11:48:18 +0000

Thanks – just what I was after!

By: mark

mark — Tue, 14 Apr 2009 23:32:54 +0000

I want to say – thank you for this!

By: codeproject

codeproject — Thu, 11 Oct 2007 21:14:53 +0000

Yes, you can create and insert values in temp table but using select query not stored procedure.

i.e.

Select * into #temp from Table

You can also insert the values into temp table from Stored Procedure but Temp table should created before.

i.e.
Insert into #tempCityEmp Exec sp_First

Hope this is your answer.

If not please eloborate in detail what exactly you are asking and what is the benefit to do this in one line and why ?

Thank you very much for your comments.

regards,

Rana

By: stan

stan — Wed, 10 Oct 2007 19:51:18 +0000

isnt there supposed to be a way of creating and inserting into a temp table in one step?