SQL Server Performance Forum – Threads Archive
Confused about result set counts?!select *
where NABPNO = ‘8888888’ COUNT: 1426
Delete from aetna_20050515
where NABPNO = ‘8888888’ COUNT: 1210
I’m confused too. I test it and no problem at all. Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Yeah i dont understand it either… I insert a copy of records that are to be removed (select into…) i double check the new table count(1426). Then go back and delete the records… but do not get the same count(1210).
I feel its not possible but check for rowcount after each operation or else update statistics and check the count(*) and not rowcnt from system table.
sounds that you might have set rowcount value. If so then dont forget to set that to 0 at the end Set Rowcount countvalue
Set Rowcount 0 Madhivanan Failing to plan is Planning to fail