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 7, 2009 at 1:27 pm

    #1088863

    Please post sample data and table schema.

    The two should return the same results. It seems that some data may be amiss, or maybe a setting in the linkedserver setup.

    It looks like you are joining to two linkedservers (one being a SQLLink 3rd party app) and a CRM database. Has anything changed in the settings for the linkedservers?

    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