rowcount help -- sql server (alternate)

D.B.
5/20/2006 5:27:36 AM

i'm trying to get total rows found by query that uses top clause...

for example:
select top 10 myTable.* from myTable where myTable.number > 200

let's say there are 13 rows matching that condition, and by using
@@rowcount my result would be: 10.

is there any way to get total row count, without affecting the TOP
clause??? i believe that the mysql equivalent would be
SQL_CALC_FOUND_ROWS().

tnx...

Dan Guzman
5/20/2006 12:58:34 PM

I answered this question in microsoft.public.sqlserver.server.

It's bad etiquette to post the same question independently to multiple
groups because that causes unnecessary duplication of effort by persons
trying to help. If you have a question appropriate for multiple groups,
specify all groups in a single post so that all responses appear in all
groups.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]

sql server (alternate) : rowcount help