Update duplicate records
Before change:
CLAIM_ID CR/RE Internal TAT 11061488 Rebill 27 11061488 Credit 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit
After change :
CLAIM_ID CR/RE Internal TAT 11061488 Rebill 11061488 Credit 27 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit
condition : if Credit - Credit for same ID, no change in TAT
if Rebill-Rebill, no change in TAT
if Credit Rebill , then check for Rebill if it has some value, if yes, then cut that value and paste it in any of credit line for same ID
Software/Hardware used:
ASKED:
November 26, 2012 12:20 PM
UPDATED:
November 26, 2012 1:04 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
11,405 pts. ,
SQLbamola 5 pts.
11,405 pts. ,
SQLbamola 5 pts. To see all answers submitted to the Answer Wiki: View Answer History.
Do you need help with something ?