With a collation of Latin1_General_CI_AS, I get the same results with SQL2019, SQL2017 and my last remaining instance of SQL2016.

A utf-8 collation will work with varchar. Extended characters will use 2, 3, or 4 bytes so...

Depending on the size of your varchar column,...

• This reply was modified 2 months, 1 weeks ago by Ken McKelvey.
• This reply was modified 2 months, 1 weeks ago by Ken McKelvey.

I have never done anything with DB2 but maybe something like CData Sync would work.

Maybe I have not had enough coffee yet, but I am having difficulty understanding how RCSI/MVCC will help with a data extract. Snapshot isolation may help and the issues with...

• This reply was modified 2 months, 3 weeks ago by Ken McKelvey.
• This reply was modified 2 months, 3 weeks ago by Ken McKelvey.

France has its own cloud provider:

Cloud Computing & Web Hosting | OVHcloud UK

The problems allegedly are:

1. The documentation, even in French, is poor.

2. The support is worse.

3. Only basic services.

ie...

It seems strange to do this in a SP; I would be more inclined to have something on an application server and use a more suitable language. (C#)

If you really...

/* *** Test Data *** */
CREATE TABLE #t
(
   Account char(7) NOT NULL
   ,TransDate date NOT NULL
   ,TransType char(1) NOT NULL
 ...

The order in which rows are returned in a result set aren't (sic) guaranteed unless an ORDER BY clause is specified.

If you are not using SSIS elsewhere, it may just be simpler to use PowerShell.

1. First create a view of your query. Something like:

SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
USE...

• This reply was modified 4 months, 1 weeks ago by Ken McKelvey.
• This reply was modified 4 months, 1 weeks ago by Ken McKelvey.

I think Databricks is a good option for production at the moment as Fabric is still not mature. Microsoft now has an issues list so hopefully it will be...

Your question is unclear so I showed you how to use FIRST_VALUE and...

/* *** Test Data *** */
CREATE TABLE #t
(
    rn int NOT NULL
        PRIMARY KEY
   ...

Just load this and weave the results into the conversation! I find it amusing when...

CDC uses the log so does not explicitly require timestamps.