Viewing 2 posts - 1 through 3 (of 3 total)
sorry I didnt understand the article
-===== Create the test table
CREATE TABLE ##TBL_AI
(PRODUCT_ID INTEGER NOT NULL,
PRODUCT_CODE VARCHAR(25) NOT NULL,
ORDER_DATE DATETIME,
TPERIOD01 DECIMAL(9,4),
TPERIOD02 DECIMAL(9,4))
CREATE TABLE ##TBL_RI
(PRODUCT_ID INTEGER...
May 22, 2011 at 11:21 am
Thanks for your help
Here is a data sample
TABLE AI
PRODUCTMQORDER_DATETPeriod1TPeriod2TPeriod3TPeriod4TPeriod5
10023AI01/07/2010414176.545.546
10023AI01/07/2010414176.545.546
TABLE RE
PRODUCTMQORDER_DATETPeriod1TPeriod2TPeriod3TPeriod4TPeriod5
10023RE01/07/2010414176.545.546
10023RE01/07/2010414176.545.546
TABLE RI
PRODUCTMQORDER_DATETPeriod1TPeriod2TPeriod3TPeriod4TPeriod5
10023RI01/07/2010414176.545.546
10023RI01/07/2010414176.545.546
May 22, 2011 at 10:25 am
Viewing 2 posts - 1 through 3 (of 3 total)