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 |
|
oasis1
Starting Member
35 Posts |
 Posted - 2013-11-08 : 11:30:48
|
| Hi all, I have been asked to project the monthly totals for the month based off of the daily average of transactions. Does anyone have a formula on how to capture max days in the month as my multiplier. I am thinking I can use date part to get the denominator to divide by. Any help much appreciated mahalo, Brew |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-08 : 12:31:55
|
| by montly days do you consider even weekends? or just weekdays? what about holidays?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Projecting monthly average