Viewing 2 posts - 1 through 2 (of 2 total)
Thank you Alan!
This one really helped me a lot.
It's strange that MS haven't implemented a parameter for SUM to stop at 0.
April 4, 2023 at 7:07 am
#4168805
Also, you can add this to the select-statement for the cursor:
select name from SYS.databases s WHERE state = 0
The script will fail if it hits on...
September 8, 2017 at 1:52 am
#1958685