I have 2 columns of UniqueIdentifier datatype. Here's a sample of 1st row
TID UID
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.