Re: cant get the correct num of rows from Oracle. in 2 SQL servers ( sql 7.0 and SQL 2000)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Melih SARICA (melihsarica_at_hotmail.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 14:36:35 +0300

Ty tibor..

Query is the same

select count(*) from openquery(baanb,'select t$item from baan.ttiitm001501')

in SQL server 7.0 this query returns 49439

in SQL server 2000 it returns 49340

and not only in this query .. if number of rows returned from the openquery
statement get biggers number of lost rows get bigger too

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:Oi34g5ctEHA.636@TK2MSFTNGP09.phx.gbl...
> Possibly handling of NULLS can cause a difference. Can you post the two
queries?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Melih SARICA" <melihsarica@hotmail.com> wrote in message
> news:%23szluxctEHA.3156@TK2MSFTNGP12.phx.gbl...
> >I ve got an Oracle 9. server running on AIx.
> >
> > and One SQL Server 2000 Sp 3on w2k
> > and SQL server 7 on Winnt 4.0
> >
> >
> > i did link this Oracle server on both SQL serevrs. When run an simple
SQL
> > query i got different results.
> >
> > Num of rows are always different In SQL server 7.0 i got 49430 rows(
when i
> > check in oracle its correct)
> > In SQL SErver 2000 i
got
> > 49336 rows.
> >
> > Any idea ?
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem using Access or Query Designer to run queries in SQL Serve
    ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
    (microsoft.public.sqlserver.odbc)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)