Was just reviewing the execution plan, and my thoughts are (experts feel free to tell me I'm wrong here):

1 - the "SELECT(COUNT()...)" statements are checking if the result is less...

Kristen,

In your scenario, I am not sure service broker is the route I would go either.  The biggest part that would make me use a different solution is that there...

Hello Kristen.  To address your concerns, messages very rarely fail to send.  For a message to fail sending, pretty much the only cases I can think of are that the...

One way would be to use a test environment (so you don't break any production data) and run all of the stored procedures and see which ones give a data...

Happy to help.  I am just glad you were on 2017 or newer as otherwise that STRING_AGG function wouldn't have worked and we'd have needed to get more creative.

Sorry about that.  Did not realize the order was important.

But that is just as easy to handle:

SELECT [Quarters]
 , [Function]
 , [Product]
 , [Manager]
 , string_agg(GM ,';...

This is pretty easy to do actually since you are on 2017!

Check this out:

SELECT [Quarters]
 , [Function]
 , [Product]
 , [Manager]
 , STRING_AGG([GM] ,'; ') AS [GM...

I personally don't see it being a problem having 1000's of messages being sent at once.  I would still send them on a single conversation.  The advantage to that is...

As a thought, what about if you switched C1 to be an IDENTITY value or a SEQUENCE or a calculated column and not insert it via a stored procedure but...

My opinion, this is a good use of service broker.  We have a VERY similar thing happening on our systems, but it is a 2-way thing with service broker.  Server...

My recommendation is going to still be get a monitoring tool.

If that is not an option, you are going to need a linked server or SSIS or something in place...

If this was my task, I would buy an ERP rather than reinvent the wheel.

If you need to do this strictly in SQL, you would need to know the "max...

Might be a dumb question, but does that need to be dynamic SQL?

My thoughts here are to take your last 2 IF statements and have them assign a value to...

Pretty sure you are going to need to configure that per-server.  The servers don't share any configuration information, so you would need to set that on on a per-database level.

Alternately,...

I think that it should work just fine.  I have used most versions of VS from 2010 through 2019 to build reports for various versions of SSRS (2008 R2 through...