To allow for some variations in the format:

SELECT string, numbers
FROM ( VALUES
    ('Total # of bytes : 128270200832 (119.46GB)'),
    ('Total #...

Select p.PREmp, p.PRDept, 0 As [Admin] 
From Payroll p
UNION ALL
Select h.PREmp, p.PRDept, 1 As [Admin] 
From HR h 
cross join (
    select distinct PRDept
...

How's about this instead?!:

SELECT
    us.Name
    ,SUM(wl.HoursWorked) / COUNT(DISTINCT us.TeamID) AS HoursWorked
FROM Users us
INNER JOIN WorkLog wl ON wl.UserKey = us.UserKey
GROUP BY...

WHEN 'SCC' THEN CONCAT(' (', CAST(ROUND([Column], 0, 1) AS int), ' ', nestedTempTableAlerts.[Threshold_Value], ')')

SELECT value AS original_value,

CAST(ROUND(value, 0, 1) AS int) AS value0,

CAST(ROUND(value, 2, 1) AS decimal(9, 2)) AS value2,

CAST(ROUND(value, 1, 1) AS decimal(9, 1)) AS value1

FROM ( VALUES(100.199) ) AS test_data(value)

That code is for one row, so whatever values you are INSERTing for the current row contains the key(s).

For multiple rows / a batch of rows, yes, you would initially...

You'll want to add ERROR_MESSAGE() at least to your CATCH code.  That will give you the specific error msg SQL issued.  You should probably go ahead and add ERROR_LINE(), although...

See if this works for you:

;WITH cte_raw_counts AS (
    SELECT COUNT(*) AS total_company_count,
        SUM(CASE WHEN rr.[company_name] =...

I think it would be more accurate and far less work to rely on the existing constraints.

You should be able to use a BEGIN TRANSACTION and a TRY/CATCH block to...

I'd do an explicit sp_recompile on all the tables affected by the renames, just to be safe.  Renaming is great, but it's a short-cut method that's not fully "recognized" by...

That shouldn't be possible. Per Logical...

I think creating a table and using EXCEPT / INTERSECT would perform better than a long string of ORs.  Either would also take care of NULL values for you.  So,...

WHERE PS.popup_gid = 5 OR
    (PS.popup_gid = 2 AND (T.record_Key_4 = '1' OR T.Record_Key_5 NOT IN ('I', 'X')))

Just CAST() the column as a date, that gives you the most flexibility with the format of the column:

CONVERT(varchar(5), CAST(alertQueue.[Pickup_Date] AS date), 101) AS PickupDate

Be sure to run the Data Migration Assistant on every user db.  Don't assume one db is "just like" another one.

If the db is open and usable after it migrates,...