Abort count if given number exceeded in SQL query

[TimSki]

This is probably a dumb question...

but,

I have a large table 10M rows. I want to do a typical sql count BUT i want to abort the count (and return me the count so far) if it exceeds a certain number

kind of...

select count(id)
from bigtable
where maxcount cannot exceed 200

any ideas ?

[code green]

select top 200 .....?

[TimSki]

thanks but that wont work because i don't want to bring back the records

[ck9663]

Do you just want to know if the number of records in a table is greater than X? If that's the case, use this view instead.

Good Luck!!!

~~ CK

[Sandeep M]

will it solve?

select count(id)
from bigtable
where.....
group by <field>
having count(id)<@limi t