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 : 03:46:50
|
| 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.we have a week index and a month index and a day index dedicated please helpcan anybody please help..... |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-07 : 11:17:08
|
| You need to write a query something like thisSELECT <your columns>FROM <your table>WHERE <an expression using your columns>Based on the info you gave that's about as specific as I can be. |
 |
|
|
|
|
|
Sql query to retrieve corresponding week last year