Please start any new threads on our new site at 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)
 Very very tough for me

Author  Topic 

Starting Member

12 Posts

Posted - 2007-03-07 : 05:41:03
Our databse gets uploaded on daily basis
We use excel for reporting cases

I need a sql query to retrieve the following cases:

Those cases which uploaded in the eqivalent week 6 months ago
Those cases which uploaded in the eqivilent week 1 year ago.

So there fore I need 5 day's worth of data on each worksheet.

Consider this month to be March,2007 and week running is second.
i need the data for september, 2006 second week.
and also i need data for March,2006 second week

we have a week index and a month index and a day index dedicated please help

can anybody please help.....

Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-07 : 05:44:01
Can you please stop cross-posting?

All are the same question!

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

- Advertisement -