Rayne
asked on
monthly To split
Hello
There is one table (monthlyData) that lists a metric quantity by month and account. These are monthly.
There is an empty table called weeklydata. I need a SQL to split the monthly amount of the metric into 4 week for each account. See attached.
month-split.xlsx
There is one table (monthlyData) that lists a metric quantity by month and account. These are monthly.
There is an empty table called weeklydata. I need a SQL to split the monthly amount of the metric into 4 week for each account. See attached.
month-split.xlsx
ASKER
see attched for idea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you Sire Vidmar,
i greatly appreciate your help.
i greatly appreciate your help.
ASKER