DECLARE

@MyResult int;

SET

@MyResult =

(

SELECT count(rowcnt

If you have some errors the statement will be terminated and temp table will be not deleted.

Thanks,

Vera