Obtaining data from extended stored procedure.

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)

Obtaining data from extended stored procedure.

Author

Topic

Wodzu
Yak Posting Veteran

58 Posts

Posted - 2008-02-20 : 07:13:25

Hi folks.

I have a extended stored procedure which returns me some data in table. It works when I call it like this:

exec xp_MyProcedure

But how to for example join data from this procedure with some table?
Do I have to insert date from it firstly to some temporary table or is there an easier way?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-20 : 07:16:58

Does this work?

Create Table SomeTable
(
col1 varchar(10),
col2...
...
)

Insert into SomeTable
exec xp_MyProcedure

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"