When you ALTER a column, SQL creates a new column to store the data, it doesn't re-use the existing space for the new column.  You'll need to do some type...

My other feeling was that having it run multiple times (2, 3, 4?) at the start of the month could be deceptive / confusing to people looking at...

@jonathan-2:

This method of determining Tuesday:

DATEPART(weekday, @CurrentDate) = 3

requires a specific DATEFIRST setting to work correctly.  Many business have locations around the world, so it's safer to use a...

Fair enough.

In that case, let's create a view that has the merged tables for anyone to use.  That is much cleaner.

Yikes, if a developer can't join/merge two tables with distinct date values to a combined table, they need additional training, and pronto.

Personally I prefer a nonworkdays-only table (I don't call it a "holiday" table because sometimes it's a nonwork day but not a holiday (such as for a power outage, etc.)).

That...

<removed, dup comment>

@jonathan-2:

This method of determining Tuesday:

DATEPART(weekday, @CurrentDate) = 3

requires a specific DATEFIRST setting to work correctly.  Many business have locations around the world, so it's safer to use a method that...

@dennis Jensen:

I never presume to know the requirements of the task better than the person requesting the code.

"If the first Monday of the month is a holiday, than I need...

I'd strongly urge you not to mess with the DATEFIRST setting.  You don't need to, and it could throw off other code which might need a different setting (if the...

I don't believe you can do this directly.  However, you could have the first step of the job determine if it is a holiday, and if so, to schedule a...

Your ordering is not guaranteed to be in the OUT ITEM order, since you don't sort by it.

If you have a lot of rows, you'd likely get better performance putting the results (from the cte) into an indexed temp table, but for now, just see if this...

An alternative that allows a previous open paren(s) in the input data:

DROP TABLE IF EXISTS #test2;
CREATE TABLE #test2 ( tran_log_writes nvarchar(4000) NULL );
INSERT #test2 ( tran_log_writes )...

Personally for something this involved / complex, I'd use a custom function that parsed with pre-determination.  That is, the code doesn't look only for specific names (tags) in the data,...