Determine which field to update based on where clause

Asked Apr 15 '19 at 15:32

Active Apr 15 '19 at 15:32

Viewed 35 times

i have to update one tables field based on the where condition.

select ttc.*,
(case 

when ttc.TagId1=t.Id  then TagDescription1 
when ttc.TagId2 =t.id then TagDescription2 
when ttc.TagId3 =t.id then TagDescription3
when ttc.TagId4=t.id then TagDescription4 
end )  TagDescription from @tagIDTable temp
inner join Table1 T on temp.ID =t.Id 
left join Table2 TTC on TTC.TagId1 =t.Id 
or TTC.TagId2 =t.Id 
or TTC.TagId3 =t.Id

above is the select statement i wrote. I have to update the tagdescription field. we have 4 tagdescriptions. based on the the where condition i need to update it. how to do the update in an optimized way

asked Apr 15 '19 at 15:32

vinton

Use a case statement in the update, with the 'else' pointing to the original field. – SeanR Apr 15 '19 at 15:33
@vinton . . . Sample data and desired results would really help. – Gordon Linoff Apr 15 '19 at 15:36
Might be related: https://stackoverflow.com/q/2334712/6327676 – DxTx Apr 15 '19 at 16:02

Determine which field to update based on where clause

0 Answers0