Update duplicate records

5 pts.
Tags:
SQL Server 2008
SQL Server 2008 64-bit

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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Do you need help with something ?
    78,795 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: