Another Group By Month solution

[Digital Man]

I glanced briefly at the telerik solution for grouping a report by month by using a custom DateTime object. I then decided to just try adding a column to my select command that would would return the month/year as a string as in:

RIGHT('00' + CAST(DATEPART(mm, TestDate) AS varchar(2)), 2) + CAST(DATEPART(yyyy, TestDate) AS varchar(4))

example: 092008

I then grouped by this and seems to work fine.

[Chris Gillies]

Hey Dan,

Can you point me to the original solution you were looking at?

Thanks!