Similar to kaj's code

with unq_prs(GivenPartNumber_Non,vcompanyid) as (
    select GivenPartNumber_Non,vcompanyid
    from #notmappedsources
    group by GivenPartNumber_Non,vcompanyid
    having...

Imo three triggers would be preferred.  Right from the start it's confusing because it's a "catch all" for the 3 scenarios, INSERT, DELETE, UPDATE.  In code each scenario is intended...

The first CTE (named 'UDT_CKB_SNAPSHOT') contains GROUP BY but no HAVING clause and no aggregate function(s) in the select list.  It's equivalent to SELECT DISTINCT which is much more readable. ...

• This reply was modified 4 years, 1 months ago by Steve Collins.

Maybe try it without the VIEW

Perhaps the spaces are present in the input data.  One quick way to get past the issue could be to import into a staging table and then use a query...

The thread is a duplicate.  Regarding just the first 4 lines of the procedure

Begin
-- these 2 should always be set in ALL sp's
--  set nocount on;...

It happened to be an article (which I vote yes also to keeping open) but idk it could've been a regular forum post.  Those come up in searches.  A new...

So a lot of folks have written articles where no one has posted to the discussions in well over a year.  If someone reads and article and has a...

duplicate

After following Ken and Jeff's advice first maybe have a look at the error handling and flow of control.  You've got TRY/CATCH all over the place and GOTO and it's...

The explanation seems somewhat open to interpretation.  Maybe you could explain why Brazil's ItemCount is 300 and not 500?  If 500 is the correct number for Brazil then maybe something...

• This reply was modified 4 years, 2 months ago by Steve Collins.
• This reply was modified 4 years, 1 months ago by Steve Collins.

You have an explicit transaction called from within BEGIN TRY/END TRY yet the ROLLBACK (which presumably corresponds to the transaction) is in the CATCH block.  Checking XACT_STATE in...

Cheers...

Hello Everyone,

I just started a developing a new application for hospitals (for maintaining hospital staff, patient, appointments etc.). I started with the database part first.

I will use APIs as...

I totally agree, Grant.

I'm looking at introducing "software engineering" as a topic to discuss at work with the data engineers, and introduce them to all of those concepts like...