I would make sure to have my  SQL2019 upgraded to one of the most recent CU's !

Microsoft SQL Server 2019 Builds

have a look at CharIndex

/* from https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql */
DECLARE @document VARCHAR(64);  
SELECT @document = 'Reflectors are vital safety' +  
    ...

What queries have you tried out yourself?

well ... actually ... a couple of months ago I got my IoT thermostat (Netatmo) because it regulates my temperature way better than me due to its learning mode.

However, I...

Lordy.  I understand...

aaaand .... you missed the most important message !

You may have fixed this little issue, but you are still using a...

Why do you want to use a cursor to do this.

Think SET !

you are using 3part naming to address the new matchcode object, remove "USE [test]" before statement INSERT INTO...

• This reply was modified 3 years, 7 months ago by Johan Bijnens.

Spot on! (no matter the chosen technology)

Alternatively have a look at "Get packages from SSIS Catalog"

it uses Powershell to download the packages

You should have removed...

check: "Checklist: Best practices for SQL Server on Azure VMs"

Does the service account of the target server ( 2016 ) have read authority for the backup file ?

There is something fishy with the question:

1. Are you really going to mix all Item types in this comparison?
2. How could you handle equal itemcount rows for a given country?

Spot on, Jeff !

The main point for people to prefer varchar over char is that their GUI development tool doesn't have to bother with trailing spaces.

Sorry, Steve, I clicked "report" in stead of quote 🙁

Closing a post after 1 year of no responses seems fair to me.