I think it has something to do with odbc settings.... i am copying a block off books online which might help

......

When the NOCOUNT option is set on, SQL Server does...

You have an attribute called Top within the select statement... that essentially limits the number of records returned.... but only the first n records... u can't get say 10th to...

Hi Simon...

you could possibly do it this way...

* use stored proc have part business logic and

* the component tier to have the rest of BL and responsibility to...