This content has been marked as final. Show 2 replies
Colleagues, good day!
Would be glad to get some advise to solve this task:
I have simple table with following structure:
i need to insert to this table several records (per each month) with this condition:
id - get previous id value
date - get monthend value
sales1 - get previous value
Sales2 - get previous value
so the result should be the following:
There's sample in the attachment.