Thank you for visiting my blog site. I am trying to scribble down a few facts and figures collated practically from almost one decade of professional experience in the world of binaries. I hope the time you spent on my site Helps you to gain what you indented to. Happy bloging :-) .....
"In the middle of difficulty lies opportunity" - Albert Einstein
Wednesday, July 15, 2009
Extract Data from Stored Procedure output into a Table in SQL
How to "Extract Data from Stored Procedure output into a Table in SQL"
There could be many ways to do this. If you are using SQL Server 2008 it would be better to have your stored procedure return a table variable.
If you are running prior versions best could be to use "INSERT INTO #tmpTable EXEC spStoredProcedure" method
I am a database enthusiast with an experience around one decade in the world of database products and project management. I believe the base molecules in binary world is nothing but data. I am passionate about working in the horizons of endless opportunities with database.
No comments:
Post a Comment