SQLTeam.com | Weblogs | Forums

2 column combination


#1

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.


#2

Learn update statement


#3

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.