I don't see T2 in your FROM clause and your ON clause looks a bit off.

You need something like this:

Select 
T1.[Company Name],
T1.[Company Number], 
T1.[ABRF] as [T1_ABRF_2018], 
T2.[ABRF]...

If there are more than matches, SQL Server throws an error.

Here is what I do:

• The rows load into stage.  At this point I don't care how many rows an...

I think we're on the same page.  You said, "if a record is present in Target table which is not present in source table, then that records should be disabled...

The only problem I've had with merge is when more than 1 row in the source matches the target.  Example:

• I have a source queuing up records in stage as...

Box configuration is only part of the equation.  Workload is another big part.  Do you get the timeout on a machine with other queries being executed on it?  Have you...

one last point, you could delete during an incremental load IF you had a field from the source indicating the row was deleted.

I'm assuming your doing a full load, right?  You couldn't be soft-deleting target rows during an incremental load.  A note of caution: when doing a full load you need to...

I feel like I've run across this before.  I'll give it some thought, but for now...have you considered Temporal Tables?

https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-2017

Window functions make queries like this easy.  Assuming you can't upgrade your SQL Server past 2008, can you offload your query to a newer version of SQL Server which supports...

Wow!  Can you find the original designers and yell at them a bit 😉

I would look for a completely different alternative if possible.  Is this a data warehouse?  IF POSSIBLE:...

I also do not know of a way to determine the originating database.

I see value in having only a single copy of your tools objects in a tools database.  Your...

Tight on time this morning so I may have overlooked some details when skimming through your post.  That said, here is what I would do:

• Add GUID and datetime2 columns...

• This reply was modified 5 years, 4 months ago by  heb1014.

Hey Xedni, 

I'm having a tough time following you on this.  Maybe because it's early and I've only had 1 cup of coffee 😉  I'll share something below which I think...

Hey Paul,

Welcome to database development.  Don't worry about what people think about your questions and just let negative responses roll off 😉

I don't have a lot...

Just curious since you didn't give a lot of background...I see that your question is focused on implementation.  What is your experience level in data warehousing?