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.
| Author |
Topic |
|
amit82
Starting Member
12 Posts |
 Posted - 2007-03-07 : 05:41:03
|
| Our databse gets uploaded on daily basisWe use excel for reporting casesI need a sql query to retrieve the following cases:Those cases which uploaded in the eqivalent week 6 months agoThose 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 weekwe have a week index and a month index and a day index dedicated please helpcan anybody please help..... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Very very tough for me