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.
| Author |
Topic |
|
MBak
Starting Member
2 Posts |
 Posted - 2009-09-24 : 04:42:29
|
| is it possible to create a view witch shows the dataset from a stored_procedure?I have a stored_procedure processing a lot of things involving temp tables and stuff (i can not do this in a view), and i have an application that needs tables and views to work with.The stored_procedure produces a dataset. "exec stored_procedure_name" shows this dataset.Is it possible to create a view that shows the dataset of the stored_procedure, so i can use this in my application? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-24 : 05:02:41
|
| If you were using SQL 2005, I would suggest re-writing your query to use CTE's if possible. On 2000, all I can suggest is creating a working table and using this to select from or create a view on. |
 |
|
|
MBak
Starting Member
2 Posts |
Posted - 2009-09-24 : 05:12:15
|
| myes, i was afraid you were gonna say that.maybe it is time to switch to 2005 or better still: 2008.thanks for the reply. |
|
|
|
|
|
|
dataset from stored procedure as view