Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 COUNT() Problem..URGENT

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-04 : 09:03:06
Amin writes "Is it possible for the record count to vary every 2 or 3 days ?
Actually in one of our application we display the statistics
of the number of records added by different users.
Now,suppose one user has added say 200 records...after 2 days it shows 198 or lesserthan 200.
The query that i am excuting is as follows..
"SELECT COUNT(*) Total FROM tblname"

Pls help..

Regards.
Thanks in advance."
   

- Advertisement -