SQL Query

Thank you Slightwv. what about the following situation?

Example:

Guid        LinkGuid     LoanNumber     LienType         ProgramCode
{f1244}  {2077a}       123456789      First Lien         Bond
{2077a} {f1244}        567345673      Second Lien    C30
{4ertw}  {w234r}       342342342     First Lien          C15
{w234r} {4ertw}        567834566     Second Lien     C30

Result
Guid        LinkGuid     LoanNumber     LienType         ProgramCode
{f1244}  {2077a}       123456789      First Lien         Bond
{2077a} {f1244}        567345673      Second Lien    Bond <-- should change to 'Bond'
{4ertw}  {w234r}       342342342     First Lien          C15
{w234r} {4ertw}        567834566     Second Lien     C30  <-- no change

Never mind Slightwv.

Sorry Thomas, cannot use update.

Thank you Slightwv. You answer work very well.

Hi,

This modified  update should work

UPDATE  t1
SET t1.ProgramCode = t2.ProgramCode
FROM myloantable t1
INNER JOIN myloantable t2 on t2.Guid = t1.LinkGuid
WHERE t2.LienType = 'First Lien'
and t1.LienType = 'Second Lien'
and t1.ProgramCode = 'C30'

Select allOpen in new window

Tested on dbfiddle see here

Regards,
    Tomas Helgi

>>and t1.ProgramCode = 'C30'

I believe the intent is to NOT hard-code values.  They can be anything.

Hi Tomas,

Thank you so much. Your code is working. That is exactly what I am looking for.