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 |
|
nisar
Starting Member
29 Posts |
 Posted - 2009-02-23 : 02:17:23
|
| HiI m running one stored procedure which returns around1000 rows now i want to create view from thisstored procedure like a from stored procedure bso i can select result like thisselect * from aanyone have idea about thisthanks and reagardsNisar |
|
|
krij
Starting Member
9 Posts |
Posted - 2009-02-23 : 03:38:35
|
| You can not create the views for stored procedure. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 10:05:41
|
| why do you want to create view from stored procedure? can you explain purpose?you could simply make procedure into table valued udf instead so that you can use it like a table in selects and joins |
|
|
|
|
|
|
view from stored procedure