Unravel Some Complex IF Logic

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 10, 2014 at 5:55 am

  #1679116

  I enjoyed the question as well. It made me really think through possibilities, so thank you.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  January 11, 2014 at 4:28 am

  #1679360

  Thomas Abraham (1/9/2014)

  ---

  Let's try to simplify:

  "Option 3 will always return an integer value for @Result" is false, as it is not GUARANTEED to provide a specific value for @Result when @AA is not equal to any of the 6 test values.

  "Options 3 and 5 are identical" is false, because even if @AA is not equal to any of the six test values, it sets @Result to 0.

  "Answers 2 and 3 are both true" is thus false, because Answer 2 is false.

  By default, "Options 1, 2 and 4 are equivalent and identical to the original code" is the remaining answer that has not already been proven to be false.

  Nice analysis Tom.

  Thanks & Best Regards,
  Hany Helmy
  SQL Server Database Consultant

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  January 15, 2014 at 2:30 am

  #1680150

  Very good question from QOTD perspective. Thanks Dwain.

• PChiragS

  SSCarpal Tunnel

  Points: 4965

  More actions

  January 21, 2014 at 9:41 am

  #1682062

  good question..

  Thanks Dwain.