>>SELECT #Temp.*, >> CASE WHEN (#Temp.S1 = #Temp.S2) OR COALESCE(#Temp.S1,#Temp.S2) IS NULL THEN 1 >> ELSE 2 END AS S3 From #Temp >>