Hi- There's not a ton to say. The sql is fairly straigtforward, and when I run it in the query analyzer I'd get, for example, 19 rows.

When I create a DataTable with the same SQL, I'll get 19 Rows
( dt.Rows.Count == 19 )

When I create the reader and do like this:

counter = 0;
while ( dr.Read() ) {
//In here look at the reader's contents for this row
counter ++;
}

at the end of this, the counter == 14;

There's really not much to it.

Any ideas? Anything else i can provide?

db