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 2000 Forums
 SQL Server Development (2000)
 How can I use stored procedure withing a view?

Author  Topic 

compound
Starting Member

7 Posts

Posted - 2006-01-25 : 14:51:58
How can I use stored procedure withing a view?

Thank you.
Compound

X002548
Not Just a Number

15586 Posts

Posted - 2006-01-25 : 15:05:23
You can't..you can store the results of a sproc to a table though

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-25 : 15:13:51
Add something to what Brett said,

U can store in a temporary table, not occupying the database space permanently, if u drop it after use.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-27 : 05:12:35
quote:
Originally posted by compound

How can I use stored procedure withing a view?

Thank you.
Compound


Why do you want to use sp from View?

Madhivanan

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

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 08:15:23
this might help
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60671
Go to Top of Page
   

- Advertisement -