Comments for Chad Petrovay

Comment on Select Top 3 * From [Uses for Select]: Part 3 by Cassidy Percoco

Cassidy Percoco — Mon, 08 Sep 2025 20:03:16 +0000

I’m trying to lear nenough about SQL to create alerts, and this was extremely helpful, thank you!

Comment on How Clean is your Database? by Chad Petrovay

Chad Petrovay — Tue, 05 Sep 2023 15:55:46 +0000

Data Cleaner is now at https://datacleaner.github.io/

Comment on A Progress Bar for SQL Scripts by Chad Petrovay

Chad Petrovay — Tue, 05 Jan 2021 03:57:20 +0000

In reply to Tyler. This script was developed to be used inside a WHILE loop. I created a table 'TempTable' to manage the loop; the table contains the key for records to be processed, and a bit (1 = complete, 0 = pending). The loop is WHILE (SELECT * FROM TempTable WHERE Processed = 0). You can replace 'TempTable' with whatever you are using for your loop or cursor, but it's an ideal application for temporary table.

Comment on A Progress Bar for SQL Scripts by Tyler

Tyler — Mon, 04 Jan 2021 21:58:01 +0000

Very new to SQL and running a long query written by a departed coworker. I’m getting this error:

Msg 208, Level 16, State 1, Line 6
Invalid object name ‘TempTable’.

Do I need to manually create this table or define it somehwere? Thanks!

Comment on Quick Start Guide by Chad Petrovay

Chad Petrovay — Sat, 29 Dec 2018 18:06:58 +0000

The download link has been updated.