TSQL Challenge 54 - Find the longest matching area code

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  April 17, 2011 at 11:15 pm

  #147789

  Comments posted to this topic are about the item TSQL Challenge 54 - Find the longest matching area code

  .

• John Bevilaqua-427875

  SSC Veteran

  Points: 232

  More actions

  April 18, 2011 at 4:26 am

  #1312663

  Curious thing is that I had to do exactly the same thing for a recent project but the code might be protected as a work for hire creation.

  The other curious thing is that the resulting code performed differently based on the setting for MAX DEGREES OF PARALLELISM until I made a change in the structure of the Transact SQL involved. Contact me for more info.