Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Help with a special type of comparison
OK. I switched the variables like this: select ID, m1, m2, m3, m4, case when m1 in ( @m1,@m2,@m3,@m4 )then 0 else 1 end + case when m2 in ( @m1,@m2,@m3,@m4 )then 0 else 1 end + case when m3 in ( @m1,@m2,@m3,@m4 )then 0 else 1 end + case when m4 in ( @m1,@m2,@m3,@m4 )then 0 else 1 end... -
Help with a special type of comparison
Thanks. That's a simple and elegant alternative. I'll try to adapt it and see if I get the expected results. -
Help with a special type of comparison
Hi, I'm new here and I've got a problem. Hopefully some of you who love a challenge can provide some useful suggestions. Let me try to explain the scenario. It has to do with comparing some values in a recordset to some previously defined reference values and in the process obtain an integer...
