Home Forums SQL Server 7,2000 T-SQL How to inner join a result set from stored procedure without creating temp table RE: How to inner join a result set from stored procedure without creating temp table
Aaron Ingold
SSCrazy Eights
Points: 9070
More actions
September 5, 2007 at 10:11 am
#731566
You're going to want to dump it into a temporary table, table variable or if possible change the stored procedure to be a table-valued function (not always possible). Then you can join to it.