• You could do away with the big CASE expression if you use the datename function:

    datename(MONTH, ins.lasUpdateDate) + ', ' + datename(YEAR, ins.lastUpdateDate)

    As for the actual problem, I assume that ins.LastUpdateDate includes a time portion, why the condition

    and ins.lastUpdateDate > Dateadd(year,-1,getdate())

    should be

    and ins.lastUpdateDate > Dateadd(year,-1, convert(date, getdate()))

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]