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:51:56
|
| 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..... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
amit82
Starting Member
12 Posts |
Posted - 2007-03-07 : 04:40:04
|
| please guys please make it fast please...sql server 2000 |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-07 : 04:46:29
|
What do you mean by "eqivalent week 6 months ago" ?"So there fore I need 5 day's worth of data on each worksheet."So you want the query that returns these data ? You have to post your table structure with some sample data and the required result.
KH |
|
|
|
amit82
Starting Member
12 Posts |
Posted - 2007-03-07 : 05:38:49
|
| 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 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-07 : 09:05:22
|
make use of dateadd() function
KH |
|
|
|
|
|
|
sql query to retrieve corresponding week last year