November 30, 2005 at 12:45 pm
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
1. are you sure the DATA is the same?
2. Can you post the query ?
* Noel
November 30, 2005 at 1:30 pm
Could you please post the query? Also check collation of SQL Server.
December 1, 2005 at 4:38 am
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