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

• sudhirnune

  SSCrazy

  Points: 2342

  More actions

  April 8, 2013 at 3:34 am

  #273152

  Hi Team,

  I have a Complex requirement.

  Source:

  --------

  NAMEPAYMENT_TYPEPAYMENT

  SUDHIRSAL30.3

  SUDHIRADV10.3

  SUDHIRALL_110

  SUDHIRALL_210

  SUDHIRALL_310

  MADHAVSAL34

  MADHAVALL_124

  MADHAVBONUS10

  Formula:

  --------

  TGT_PAYMENT_TYPEPAYMENT_FORMULA

  SAL SAL-ADV

  COMM ALL_1+ALL_2-ALL_3

  BONUS SAL * 1.1

  Target Table:

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

  NAMESALBONUSCOMM

  SUDHIR20010

  MADHAV341024

  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.

• sudhirnune

  SSCrazy

  Points: 2342

  More actions

  April 8, 2013 at 8:28 am

  #1604437

  Hi All,

  Please need some help or clues...! 🙁