Hello every one,
Could someone please help me with the below sceanrio.
I want to split the rows of one table based on date range of another table.
I have table called sfe and sfe_exp
Based on the sfe_exp table date range i want to split the recors in sfe table by altering the data, when add_remove = 1 then i have to add the quantity , when it is 0 i have to substract the quantity.
Below is the sample datasfe
Can someone please help me with this sceanrio