• 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