Less than four functions, anyone?

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

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