Post reply

create table valued function

  • July 30, 2013 at 1:59 pm

    #1637111

    U rock!! It worked awesome. I would never thought of rewritting it like that. Runtime is now 1 sec from 7-8 sec which is awesome. Thank you!!!

  • July 31, 2013 at 8:44 am

    #1637412

    Why is this part of your code?

    AND ISNULL(TableZ.MyCol,'') + '/' + ISNULL(Table2.MyCol,'') + '/' + ISNULL(Table3.MyCol,'')

    + '/' + ISNULL(Table4.MyCol,'')+ '/' + ISNULL(Table5.MyCol,'') IS NOT NULL

    Using the ISNULL followed by a check that it IS NOT NULL will always evaluate to true. It just extra processing for nothing (unless there's something I'm missing?).

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply