Is there anything better than DatePart to GroupBY Week/Month/Year

[yomero]

I have a DB that has a couple millions of records and growing, and every record has a timestamp field which includes YYYY/MM/DD : HH:SS

I produce weekly and monthly reports, I am using DATEPART in 3 custom columns to be able to group by Week and Month and Year.

Is there a better way to do this?

 

[GiveMeABreak]

What is wrong with your current method?

 

[HiTechCoach]

if you are sorting on the timestamp field make sure it is indexed.

I produce weekly and monthly reports, I am using DATEPART in 3 custom columns to be able to group by Week and Month and Year.

That is how I would do it.


Another option is to use Format(). Example: I use Format([timestamp], "YYYYMM") to group on months in year order.