2000 isnull vs 2005 isnull

• pkrieg

  Mr or Mrs. 500

  Points: 538

  More actions

  January 4, 2007 at 12:40 pm

  #171759

   

  This join worked in SQL 2000.  In SQL 2005 it hangs.

  I need to receive a -1 IF the select does not get a hit.

   

  INNER JOIN insrs WITH (NOLOCK) ON insrs.insrsid = isnull((select top 1 insrs1.insrsid from insrs as insrs1 with (nolock)

  where insrs1.ticketsid = #PAX1.ticketsid

  and insrs1.submittal_status = '1'

  and insrs1.deleted = 'N'

  order by insrs1.filed desc),-1)

   

  Thanks for you help,

  Phil

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 4, 2007 at 3:10 pm

  #681346

  Do you mind to try with coalesce instead and see ?

  coalesce((your select stuff here),-1)

  Also Hints are nothing but that; "hints". It does not means that you will be granted that isolation, although *most of the time you do*.

  
  * Noel