Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  date range

Author  Topic  nomvula Starting Member 3 Posts Posted - 2006-08-10 : 07:56:06 hi i'm creating a report using Reporting Services and i need to display the data from the startdate which is 01/06/2006 to current date but in the report i have to set a week range, for instance if i run the report today it should give me values from the startdate each week displaying in a row up to todays date, like Week1, Week2, Week3, etc thanks in advance