Workdays flag causes error when @get_all_databases = 1 about darlingdata

[tominyorks]

After much confusion believing that dynamic SQL was the issue, I found the actual issue is with the population of the #am_pm table which occurs inside the main database_cursor. This means once the first database has been processed, duplicate rows are entered in this temp table on the second time around the cursor, and we then get the Subquery returned more than 1 value error.

[erikdarlingdata]

OOH! That's awesome, thanks for catching it. I was just about to push an improvement for something in HealthParser, so I'll have a fix out for this in the same thing. Refresh in a couple minutes.

[tominyorks]

Yowsers....that was quick! Thanks @erikdarlingdata

Edit: p.s. can confirm this now works perfectly.

[erikdarlingdata]

@tominyorks hahaha, yeah, well, you did all the hard work. I just forgot to add a truncate statement to #am_pm like I had to for some other tables. I suppose it would have been more obvious if I had a unique constraint or something on it like I do the others.