sudhirnune (4/9/2013)
Data in the Test Formula isTGT_PAYMENT_TYPEPAYMENT_FORMULA
SAL SAL-ADV
COMM ALL_1+ALL_2-ALL_3
BONUS SAL * 1.1
There's only one formula in the table? Are you expecting more? If so, can you show how they might look?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden