Why do I get the feeling that this person just wants a solution handed to them?

It really comes down to what is needed.  For instance, I tend to use ISNULL more than COALSCE, it really comes down to what I need to accomplish. As for GETDATE()...

I have been working with SQL Server for over 20 years. More than 15 years ago I would have been more than willing to jump in on network and SMTP...

Not only that, you still didn't answer my question.

My problem, you say things didn't work, but you aren't showing us what you tried or the actual error messages you have been getting.  We are all volunteers here trying...

My first question is can you connect to Larry from SSMS running on a different system.

What does the procedure RethrowError do?

My pleasure.

Okay, just curious, what does this return:

SELECT
  [t].[charge_ctr]
  , [t].[transaction_date]
  , SUM([t].[AMOUNT]) AS 'SumAmt'
  , [t].[status]
  , COUNT(*) AS 'RecCnt'
FROM