+1 billion on FOMONTH. How on earth was that not so obviously needed for exactly the same reason as EOMONTH? Grrrr.

One subtle thing to be careful of is the difference between these two styles if you don't get any rows as a result from the query. Using SET will result...

9.2 isn't an int, use a suitable decimal or float type for an average.

Excel has a lot of things called filters and it's not at all clear which one you are talking about. How is the data getting into excel? Where are the...

There is clearly still a long road to go before people default to learning...

Given the choice, I'd opt for a Table Valued Function over a Stored Procedure if possible. Yes SPs do return the results of Select statements and if all that matters...

If you're talking about a filter in an Excel column, yes it's still basically the exact same problem and you still can't possibly have all 9.5 million rows in Excel...

CREATE PROC WYZ
AS
BEGIN
 BEGIN TRY
  BEGIN TRANSACTION

WHERE USER_NAME() <> 'Specfic User' OR ColumnToCheck=1

should do the trick

Something like:

Insert Into TableB
(
   TableName,
   cola,
   colb,
   colc,
   user_name,
   action,
   deletion
)
Select
   TableName,
   ...

Do the replace after converting to JSON, i.e.:

Select
 Replace(
  Replace(
  (Select * from #Event_Total for json path),
  Char(10),
  ''),
 Char(13),
 ''
)

Although I don't...