Using select count(*)

[timscronin]

To get an accurate up to data row count on a table, is

select count(*) from table where
autodate is null

still the most Efficient way, for some reason I thought there was something better

 

[r937]

it will be efficient only if there is an index on autodate

r937.com | rudy.ca