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 |
|
m.sunils
Starting Member
10 Posts |
 Posted - 2007-05-10 : 19:49:12
|
| Is there a way to execute an SP inside a view?I have a requirement where in i have to use a cursor to generate a particular result set and want this result set to be available as a view.But neither cursors nor SPs are supported in a view.How can i have a work around for this situation.Thanks,Sunil. |
|
|
herothecat
Starting Member
19 Posts |
Posted - 2007-05-10 : 20:01:24
|
| Nope, SP's can't be used in a view.If you can give more detail on your requirements someone may be able to help.Why push the envelope when you can just open it? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-05-11 : 01:00:32
|
quote:
Originally posted by m.sunils...I have a requirement where in i have to use a cursor to generate a particular result set ...
Why would that be an actual requirement?Does this mean that you just don't know how to do it with a set based query?CODO ERGO SUM |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-05-11 : 01:32:33
|
| You can use a function in a view, not a sp |
|
|
|
|
|
|
Using SP's in a view.