Hi Experts,
I have a scenario like this
Table 1.
week_no start_date_of_week end_day_of_week
1 22.09.2008 28.09.2008
2 29.09.2008 05.10.2008
3 06.10.2008 12.10.2008
Table 2
Article Qty Delivery Date
A 10 24.09.2008
B 30 20.09.2008
C 25 01.10.2008
Then output should be in Table 3 as
Article Qty Week
A 10 22.09.2008
B 30 22.09.2008
C 25 29.09.2008
Means if the delivery date is in the past, put the order in the current week otherwise determine under which week the delivery date will fall, put order in that week.
Please help me in this scenarion.
Thanks
krishan