Service Broker (not sure it works in express but I expect so) would be another option and would be near real time, but may also be overkill.  Linked server and...

I would do something like

SELECT appt_time + duration as end_time

BUT that assumes that the datatypes on those 2 columns can be added together.  For example, if they...

I would start by comparing the data in the two systems.  Pick a table and compare the values between the two.  It COULD be that the user expected data, but...

If you NEED to do this in SSIS, I think you are going to need a for each loop (or similar).

If you can do this on the TSQL side before...

I agree with ScottPletcher here that there is little value in that sort of assessment and there is a LOT of things that can impact it.  If your table has...

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...