SQLTeam.com | Weblogs | Forums

Mathematics and sql


#1

Hello Techie, may anyone please suggest me how to proceed with this
for a given sales manager, sales group, salesperson and customer there is some net product sales in total sales table , which I need to divide base on total number of working days
with the help of Working days in a month table

Kindly share your expertise. i have just shown only few month , this i need to for full calendar year.
Thanks


#2
select sales.[net product sales] / wkd.Working_Days as [net per working day]
from [total sales table] sales
join [working days in month] wkd
on sales.year = wld.year