Hi.
I need some help with an update.
I have this:
Server1
CODE FORMAT
HO00105285 0000000002
HO00105285 VS00000001

Server2
CODE FORMAT
HO00105285 0000000002
HO00105285 VS00000001

I need to bypass those on an update and only do an update if the values have been changed on FORMAT

Doing this:

Code:
	UPDATE Server2 
	SET Format = HO.Format
	FROM Server1  as HO inner join  Server1  FF on FF.CODE COLLATE Greek_CI_AS = HO.CODE and FF.Format COLLATE Greek_CI_AS <> HO.Format
This will always update the above 2 lines even if they are equal on both servers on CODE's that are 2 liners or more.
How would I go about and ignore them and only update if the Format is different ?