Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: calculation for the multiple periods in the date range

    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...

  • RE: calculation for the multiple periods in the date range

    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

Viewing 2 posts - 1 through 3 (of 3 total)