SQLTeam.com | Weblogs | Forums

2 column combination


I have 2 columns of UniqueIdentifier datatype. Here's a sample of 1st row
056-007 032-555

If TID(056-007) is followed by UID(032-555) update display name(3rd column). If, it's not, do nothing. It's
kinda like a combo match. the SQL needs to go to 2nd row and so on. I've tried CASE but doesn't seem to work.


Learn update statement


Please show the code you have tried. You only show two columns but talk about three. Please give a few rows of input and desired output.