Another thought (as I ran into a similar issue when working with Great Pains... I mean Great Plains) - try setting your MAXDOP on that query to 1.  We had...

How are you mapping "REG1" to "SICK1" and REG2 to SICK2?  You would need something to JOIN on.

Using the data you have given, I see no way to map those...

My opinion on the fix - try checking off the other box in the Exchange configuration (use windows authentication) UNLESS you are not using windows authentication for Exchange authentication.  If...

Might be a dumb question, but wouldn't the answer marked as "correct" give you a result different from the expected result?

I say that it might be a dumb question because...

Just to confirm, your query is in the logical format of:

DECLARE @dynSQL NVARCHAR(MAX)
SELECT @dynSQL = 'SELECT 1 AS [result]'

EXEC (@dynSQL)

And you are wanting to insert the results...

I think an article that would be helpful is this one:

https://www.sqlservertutorial.net/sql-server-basics/sql-server-like/#:~:text=The%20SQL%20Server%20LIKE%20is%20a%20logical%20operator,statements%20to%20filter%20rows%20based%20on%20pattern%20matching.

Basically, you are wanting your LIKE syntax to determine if it is numeric OR numeric with a - in it. ...

Enabling SSL would encrypt the connection between the source and destination.  One of the main benefits of SSL is that MITM (man in the middle) attacks don't work on them...

I would first determine what you need to do with the data and if this is a long term solution (ie you are going to need to do this import...

I have not run into this, but I have a few thoughts.  First, are you using SSMS 2012 or a newer version?  I know with some things (SSIS comes to...

You make some good points Scott.  I think my approach had been that NOLOCK, like CURSORS, should be avoided except where absolutely necessary.  It was what I had read in...

Scott - I agree that NOLOCK has its purposes, as do all query hints.  Otherwise they wouldn't be in there to begin with.  I was just trying to over-emphasize that...

Do you have any database monitoring tools (such as RedGate SQL Monitor)?  If so, put the alerts in there.

If that isn't an option, I think you are going to need...

To add to what pietlinden said, I think that a DISTINCT and a SUM are going to be your friend in this query.

This is also just my preference, but I...

As a random thought, IF your variables are coming from a 100% safe place OR you restrict the stored procedure so that only DBA's can run it, what if you...

My opinion - each "feature" of SQL that you enable requires knowledge and skills on how to work with it.  For example, if you turn on memory optimized tables, do...