You can also add a grouping on MONTH(SomeDateTime) without adding it to the SELECT list. It won't actually change the grouping at all, since grouping on month name and...

SELECT SYSTEM_USER

Hello 500,

If you cannot negotiate a redesign, I hope this workaround can help:

-- **** BEGIN PART WE DO NOT HAVE CONTROL OVER ****

CREATE TABLE Parent

(

ID INT IDENTITY(1,1),

Code1 CHAR(1),

CONSTRAINT PK_Parent_ID PRIMARY...