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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-08 : 15:22:49
|
Joerg writes "Hi all,
I'm using a stored procedure to create a result list out of 6 tables with some calculations and other funny stuff. Now I would like to search within this results using another stored procedure. At this place I have some problems with the syntax; 'SELECT a,b,c FROM sp_name' gets an error. I solved this problems with views using nested select statements, but this doesn't work in the stored procedure.
Where am I wrong?
Thanks
Joerg" |
|
|
|
|
|
stored procedure searches in result list of an other stored procedure