SQL Server Performance Forum – Threads Archive

Confused about result set counts?!

select *
into aetna_20050515_8888888
from aetna_20050515
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
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
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).

Hi dconallen,
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
–Execution
Set Rowcount 0 Madhivanan Failing to plan is Planning to fail

]]>