Wading in without any knowledge of Azure Data Factory at all... it seems like maybe the system is expecting a "pagination_token" along with the initial request?  You're telling it how...

Why does a single datetime of a "mess up" apply to every vehicle worked on subsequently during that day?  What if the mistake was made at 11:59PM there's only 1...

Seems similar to the other recent question

with parts_cte(partid) as (
    select partid 
    from #temp
    group by partid
...

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 3 years, 7 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 3 years, 7 months ago by Steve Collins.
• This reply was modified 3 years, 7 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...