Click here to Skip to main content
15,896,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
i have a stored procedure, which return three resultsets(as datatable). I want to call this SP from another SP(SP2) and get these resultset to that SP or atleast one table ..

thanks in advance.
Posted

See example...
SQL
create table #temp
( field1 nvarchar(146), field2 sysname, field3 nvarchar(64), field4 nvarchar(64),field5 nvarchar(64),field6 nvarchar(64),field7 nvarchar(2126))

insert into #temp ( field1 , field2 , field3 , field4 ,field5 ,field6 ,field7 )

exec sp_helpconstraint 'existingtable' ,'nomsg'

select * from #temp

Happy Coding!
:)
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900