system stored procedure result into a table.

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)

system stored procedure result into a table.

Author

Topic

js.reddy
Yak Posting Veteran

80 Posts

Posted - 2009-04-27 : 09:26:54

Hi,

I have a small issue.
I want to store the system stored procedure result into a table.

For example

sp_helpindex Prc_Market

index_name | index_description | index_keys
-----------|--------------------------------------------------|-----------------------
IX_Market | nonclustered, unique located on PRIMARY | MarketName, idRegion
PK_Market | clustered, unique, primary key located on PRIMARY| idMarket

I want to store the above result into a table.

Is it possible.

Regards
Js.Reddy

svicky9
Posting Yak Master

232 Posts

Posted - 2009-04-27 : 09:42:59

Storing Stored Procedure Results in a table.

http://www.sqlserver007.com/2009/04/07/output-of-a-procedure-in-a-table/

http://www.sqlserver007.com

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-27 : 09:45:34

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/26/select-columns-from-exec-procedure-name-is-this-possible.aspx

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-27 : 09:45:35

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/26/select-columns-from-exec-procedure-name-is-this-possible.aspx

Madhivanan

Failing to plan is Planning to fail

js.reddy
Yak Posting Veteran

80 Posts

Posted - 2009-04-27 : 09:51:39

Thanks to All

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources