I am writing a report from an historical database that uses posting_times. The way the posting works is if something has a posting time of 01/01/97 00:00:00 it means that the record covers from 12/31/96 00:00:00 to 01/01/97 00:00:00.
This is where my problem is at. The report i am writing needs to be grouped by Month. Before i figured out how the posting dates worked i was using ... DATEPART(month, posting_time) AS monthDate ... for grouping purposes in the report.
Now that i have figured out how the posting dates work i am at a total loss as how to group this. I am using SQL Reporting Services 2000 to write this report. Any help would be greatly appreciated. Thanks Mitch
I don't use that particular subproduct of SQLServer, but can you simulate what you need datawise in any way in regular SQL and then apply the lessons learned onwards??
That comes from a lot available for lateral thinking, due to amount of time spent in a horizontal position from ducking the amount of cr*p that gets throw at me at work!!! Glad you are motoring!!!
Grouping 1 off
Posted - 02/23/2006 : 14:46:38
