Stored Procedure within a 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 2000 Forums

SQL Server Development (2000)

Stored Procedure within a stored procedure

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-20 : 09:45:15

Brian writes "Is is possible to call a stored procedure within a stored procedure and use the output parameters or recordsets within that proc.

FYI, your site Rocks!"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-04-20 : 09:56:16

yes


create procedure sp1
as
begin
    create table #temp
    (
        ....
    )

    insert into #temp exec sp2

end

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-20 : 10:25:38

And note that temp table should have same number of columns with identical datatypes of what called sp returns

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources