Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Use a stored procedure result as a table

Author  Topic 

koulou
Starting Member

2 Posts

Posted - 2008-07-01 : 10:59:59
Hi !

I would like to know if it possible to create a query which will select data from the result of a stored proceture.

Thanks you

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-01 : 12:00:56
Yes.

Insert into[newtable with same columnname]
Exec dbo.sp
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-01 : 16:43:22
Also refer
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/26/select-columns-from-exec-procedure-name-is-this-possible.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

koulou
Starting Member

2 Posts

Posted - 2008-07-02 : 03:54:38
Many thanks !!!
Go to Top of Page
   

- Advertisement -