SQL Help
From: NN <nav.naid_at_gmail.com>
Date: Wed, 13 Feb 2008 07:41:52 -0800 (PST)
Message-ID: <9754b4a7-a07a-4d69-ba90-e555dbae4612@v46g2000hsv.googlegroups.com>
Date: Wed, 13 Feb 2008 07:41:52 -0800 (PST)
Message-ID: <9754b4a7-a07a-4d69-ba90-e555dbae4612@v46g2000hsv.googlegroups.com>
I have a table on Oracle
Product Store Day Promotion_Days 1 A 01/01/2008 2 2 A 01/05/2008 3 1 B 01/09/2008 3 5 D 01/11/2008 2 9 F 01/21/2008 1 1 A 01/31/2008 3
Now I want to expand the table to create a view and include a column that will include the dates the promotion is valid. The logic to calculate that is Day + Promotion Days so if you take row 1 as in the above table you should read it as - For Product 1 in Store A the Promotion starts on 01/01/2008 and lasts for 2 days 1.e until end of 01/03/2008
Now my final Table or View will look like
Product Store Day Promotion_Days Promotion_Valid_On 1 A 01/01/2008 2 01/01/200/8 1 A 01/01/2008 2 01/02/2008 2 A 01/05/2008 3 01/05/2008 2 A 01/05/2008 3 01/06/2008 2 A 01/05/2008 3 01/07/2008 1 B 01/09/2008 3 01/09/2008 1 B 01/09/2008 3 01/10/2008 1 B 01/09/2008 3 01/11/2008 5 D 01/11/2008 2 01/11/2008 5 D 01/11/2008 2 01/12/2008 9 F 01/21/2008 1 01/21/2008 1 A 01/31/2008 3 01/31/2008 1 A 01/31/2008 3 02/01/2008 1 A 01/31/2008 3 02/02/2008
I am stumped and any help will be appreciated. Thanks in advance. Received on Wed Feb 13 2008 - 09:41:52 CST