LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » Stored Procedures, Triggers, & Functions » Best approach in Getting Detail and Summary Data using stored proc

Best approach in Getting Detail and Summary Data using stored proc

Options

Previous Topic · Next Topic

rgm3159

Posted: Monday, February 07, 2011 10:15:41 AM

Rank: Newbie

Joined: 6/8/2010
Posts: 4
Points: 12
Where do you live?: NJ

Hi Scott, everyone,

I just want to ask what is your approach or best approach if you need to get the Detail data and Summary Data uisng stored proc? Do you need two separate StoredProc or you can do it in one StoredProc?

My stored proc is already using INSERT INTO EXEC spTest to get the detail data and It will not allow to nest another INSERT INTO Exec if I use another stored proc to get the summary

Thanks a lot.

RGM

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.