Home Forums SQL Server 2008 SQL Server Newbies how to combine multiple stored procedures RE: how to combine multiple stored procedures
rhythm.varshney
Ten Centuries
Points: 1138
More actions
December 20, 2012 at 12:32 am
#1570421
eklavu (12/20/2012)create temporary tables using dynamic query base on the resultset. Temporary tables are accessible in another SP and from that SP, you can join the two tables.
eklavu (12/20/2012)
Sorry mate but You can not use temporary tables in other SP.