>>Did you try having an index on the group by expression?
>>
>>Also, you do really need to convert to char? why not grouping by YEAR(Invoice.ModDate) directly? (and having an index on it too might help)
>
>In SQL Server you can not create an index on expression. Only if it's a computed column.
Oh, yes, little detail I forgot... sorry Michel! But still you do not need the convert in my opinion, although I already proved I could be wrong!
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges