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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Do you need help with something ?
    68,405 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following