Home Forums SQL Server 2005 Business Intelligence Query Optimization help RE: Query Optimization help
Lynn Pettis
SSC Guru
Points: 442467
More actions
October 19, 2013 at 9:22 am
#1659921
Not knowing what changes you made to your code I made a simple change, I moved your CTE pdtmstr into a select into statement to populate a temporary table called #pdtmstr. I then replaced the reference to the CTE with this temporary table.