Lynn Pettis (8/8/2014)
There are other issues with your query, but lets not worry about that just yet. Another question, what edition of SQL Server are you running?Also, is the intent to keep 3 months of data in the table going forward?
If so, is that 3 months plus the current month?
Yes its the current month and last three months i.e. May, June, July and August.
I am using SQL Server 2008 R2