TSQL 7.0, More limiting whereclause reduces # returned rows 
Author Message
 TSQL 7.0, More limiting whereclause reduces # returned rows

Hi

select * from vfFinanceSKU where PFATYPEID = 10 and reportingunitid = 103
and currencyid = 'USD' and yearID = 1998
returns 624 rows ending with (624 row(s) affected) which is correct

select * from vfFinanceSKU where PFATYPEID = 10 and currencyid = 'USD' and
yearID = 1998
returns 99rows ending with  (99 row(s) affected) which is wrong, should be
624 becauce all rows for reportingunitid = 103 have currencyid = 'USD'

TSQL 7.0 Query analyzer and same result at client accessing DB via RDS and a
server object

Should one be extremly scared or are we doing something wrong here????

regards, Peder



Thu, 06 Sep 2001 03:00:00 GMT
 TSQL 7.0, More limiting whereclause reduces # returned rows

Peder,

 It does indeed look like a bug, but can you supply a repro script?

 Q.  What is a reproduction (repro) script that I need to produce for a SQL
Server bug?
(v1.0   12.1.1999)

A.  In order for Microsoft to resolve a bug they need to re-create it on their
systems.  The best way to do this is to provide them with a repro script - this
needs to show the problem when run on a brand-new install of SQL Server on a
new database.  Therefore it needs to contain all tables, user defined data
types, triggers, views etc. needed to show the problem.  If it needs data then
try and keep this to a minimum.  

If the script/data is reasonably short then post to one of the newsgroups and
one of MVP's can report it to MS for you.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp



Fri, 07 Sep 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Newbie: No. rows returned from SELECT in TSQL

2. limiting the number or rows returned

3. RowNum - limiting rows returned

4. How limit rows returned

5. Limiting the Number of Rows returned

6. Limit Rows Returned from SQL Stored Procedure

7. Limit Number of Rows Returned (SQL 6.5)

8. SQLXML XPath query - how to limit rows returned

9. limit rows returned in query?

10. Limiting Rows Returned From Select

11. Limiting the Number of Rows Returned

12. Limiting the size of rows returned?


 
Powered by phpBB® Forum Software