Hello
Please need help with Part 2 . how to join data from temp table
am trying to create a simple stored .
1. that dumps the results of 2 view into 2 different temp table . this works fine
SELECT * INTO #temptable FROM vwdata1
SELECT * INTO #Temptable2 FROM vwdata2
2. Run my final query by Joining the data from these 2 views in the same stored proc.this doesnt work
SELECT * FROM #temptable
INNER JOIN
SELECT * FROM #Temptable2
Please need help with Part 2 . how to join data from temp table
am trying to create a simple stored .
1. that dumps the results of 2 view into 2 different temp table . this works fine
SELECT * INTO #temptable FROM vwdata1
SELECT * INTO #Temptable2 FROM vwdata2
2. Run my final query by Joining the data from these 2 views in the same stored proc.this doesnt work
SELECT * FROM #temptable
INNER JOIN
SELECT * FROM #Temptable2