Posted - 03/07/2007 : 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.....