Post reply

Query giving inconsistent results

  • November 30, 2005 at 12:45 pm

    #169635

    I have a query which returns different results on SQL Server 2000 standard edition with SP4 and Enterprise edition with SP4. I have the same database installed on both the servers.

    Any ideas on this?

     

  • November 30, 2005 at 12:50 pm

    #606847

    1. are you sure the DATA is the same?

    2. Can you post the query ?


    * Noel

  • November 30, 2005 at 1:30 pm

    #606856

    Could you please post the query? Also check collation of SQL Server.

     

  • December 1, 2005 at 4:38 am

    #606992

    There are several things that can affect results of a query... ANSI NULLS ON/OFF, language, date format, case sensitivity. Probably some more that I don't remember at the moment - but if you post the query, and what the results are (how they differ), I'm sure someone will be able to come up with an aswer.

Viewing 4 posts - 1 through 3 (of 3 total)

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