Record Count | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Record Count

How to get the total no. of records (not pages) to be displayed on the header/footer? I don’t find any global constants for the same. Is it required to have an additional column (count(*)) in sql query or is there any other means to get the record count.