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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-09-27 : 03:01:45
|
| hello friends!I want to display the reports in weekly format supposetoday is sept 27 2006, so i know from datepart(weekday,..) its value is 4 and end of this week is sept 30 2006 and again next week will start like that....also search should be monthly...my report looks likeWeekly Report (09/27 - 10/12)Week====09/27-09/30======10/01-10/07======10/08-10/12Sales======50===============100===============80like that my output looks likeT.I.A |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-09-27 : 03:44:41
|
| hey...gud memory!!thanks |
 |
|
|
|
|
|
Display weekly , monthly report