Home Forums SQL Server 2005 T-SQL (SS2K5) n.value = isNull(@Value,n.Value) Different Record Counts Returned. RE: n.value = isNull(@Value,n.Value) Different Record Counts Returned.

  • December 6, 2009 at 4:55 pm

    #1088307

    Should the line:

    AND b.HC_STAFFID = isnull(@HC_STAFFID, b.HC_STAFFID)

    be as is, or should it be the following?

    AND b.HC_STAFFID = isnull(@STAFFID, b.HC_STAFFID)

    I don't see a variable declared for @HC_StaffID.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events