Problem in exec - 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)

Problem in exec

Author

Topic

samamun001
Starting Member

17 Posts

Posted - 2004-12-06 : 06:56:30

hi there,
I am executing one stored procedure into another stored procedure like the following way

create procedure spTest
execute spTest1
'the spTest1 returns a recordset and
'I want to hold the recordset and parse it
'here. How can I do this plz Help me

samamun

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-06 : 07:36:20

create a temp table with the correct structure and

insert #tbl
exec spTest1

==========================================
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.

samamun001
Starting Member

17 Posts

Posted - 2004-12-06 : 08:00:20

Ohhh It works Thank U very much

samamun

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources