Selecting Stored Procedures - SQL Server Forums

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)

Selecting Stored Procedures

Author

Topic

db_sysadmin
Starting Member

27 Posts

Posted - 2006-11-07 : 09:28:08

Hey guys, is there a way to select the output of a stored procedure excecution? or some other workaround to acomplish something like this...

I.E

SELECT * FROM sp_test WHERE col1 = 1

Thanks in advance

nr
SQLTeam MVY

12543 Posts

Posted - 2006-11-07 : 09:30:18

try
set fmtonly on
exec mysp
set fmtonly off

It won't work if temp tables are involved.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

db_sysadmin
Starting Member

27 Posts

Posted - 2006-11-07 : 12:48:44

Thanks for your answer!, I just can't figure out how to filter the sp output.

like if it was a WHERE clause...and I can't hardcode it into the stored procedure because the input params, change the filter fields...

Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources