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 |
|
cmrrive
Starting Member
6 Posts |
 Posted - 2012-04-05 : 14:00:49
|
| I need some help.The final report will look like this 03/1/11 03/2/11 03/3/11 03/04/11 03/5/11 Monday Tuesday Wednesday Thursday Friday SaturdayPriorYear 0 100 100 1000 150 250 CurYear 0 0 0 1000 100 1000So I have to compare the 1st week of March 2011 with the firts week of March 2012 (and day by day like Monday, Tuesday, etc)I have a table with already with the following infodate, Amount Any help on how to built the final table?.miguel |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Weekly comparison Prior Year vs Current Year