Record Count Help

[excalibur78]

I'm running a dynamic select top x command where x can be more records then are in the recordset. x can be 600 and when you execute the select top 600 ..... it only returns say 200 records since that's all there is. Now I run the same select and only want 50 records. How can I store the actual record count? I tried "select top 50 count(*) ...." and it only gives me the the max recordset number in this example 200 even tho I said top 50.


Thanks

 

[AWithers]

Not sure I exactly get what you want but what about something like this


select count(*) from yourtable where yourkey=ANY
(select top 50 yourkey from yourtable)

Andy

 

[SQLSister]

If I understandw hat you are getting at, try somethinfg like this (I used one of my tables as an example, use your own table and field names)

select count(*) from (select top 50 AirportID from Airport) AP

The AP is a derived table alias you could use any name you wanted here

 

[excalibur78]

That worked Thanks everyone =)