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)
 Help on Stored Procedure results

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-27 : 07:57:31
Manvinder Singh writes "I want to store informaion returned by System stored procedure into a temporary table.
e.g.
I want to filter information returned by sp_who2.

How can I do it using T-SQL.

Please provide help on this."

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-10-27 : 09:20:02
you create the table which matches the sp_who2 ouput..
and then run the

Insert <Table_Name>
Exec Sp_who2



Complicated things can be done by simple thinking
Go to Top of Page
   

- Advertisement -