Post reply

SQL to transpose data using the Formula from a Different table.

  • April 8, 2013 at 3:34 am

    #273152

    Hi Team,

    I have a Complex requirement.

    Source:

    --------

    NAME PAYMENT_TYPE PAYMENT

    SUDHIR SAL 30.3

    SUDHIR ADV 10.3

    SUDHIR ALL_1 10

    SUDHIR ALL_2 10

    SUDHIR ALL_3 10

    MADHAV SAL 34

    MADHAV ALL_1 24

    MADHAV BONUS 10

    Formula:

    --------

    TGT_PAYMENT_TYPE PAYMENT_FORMULA

    SAL SAL-ADV

    COMM ALL_1+ALL_2-ALL_3

    BONUS SAL * 1.1

    Target Table:

    ------------

    NAME SAL BONUS COMM

    SUDHIR 20 0 10

    MADHAV 34 10 24

    Please need help to code SQL Query / Package which will take the Formula on from the table Formula and apply on Source before pushing it to target.

    Thanks & Regards,

    Sudhir Nune.

  • April 8, 2013 at 8:28 am

    #1604437

    Hi All,

    Please need some help or clues...! 🙁

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

You must be logged in to reply to this topic. Login to reply