How to output result from stored proc

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 2005 Forums

Transact-SQL (2005)

How to output result from stored proc

Author

Topic

ryanlcs
Yak Posting Veteran

62 Posts

Posted - 2010-05-14 : 01:32:49

Hi

This built-in function will return 2 tables, how can I output either 1 or 2 result table into my own table?

exec Sp_spaceused

Thanks.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-05-14 : 02:40:13

quote:
Originally posted by ryanlcs

Hi

This built-in function will return 2 tables, how can I output either 1 or 2 result table into my own table?

exec Sp_spaceused

Thanks.

This is not possible from t-sql
You need to use a front end application and using recordset object pull second result set

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources