Multiple calls to sqlpackage.exe, with as many different source/target...

If you want a coded solution, please provide DDL, INSERT statements, desired results etc. You know the drill.

I work on sql server 2019 i have issue i can't get percentage of two string from table

so i will compare between two string columns (PartText,MaskText) and i will...

One of the arguments for the SQLPackage command line (link) when Publishing a DB is TargetDatabaseName. Using this, it's quite straightforward to deploy the same DACPAC to multiple databases.

The enable_ordinal argument for STRING_SPLIT is not implemented in 2019.

Here is one way. It assumes that none of the partner_name columns are NULL – some JOIN tweaking may be required if they are.

DROP TABLE IF EXISTS...

Jonathan, I'm going to try your suggestion. I don't think it will work because it should be splited after ' - ' always and show me everything after that...

Using Jonathan's test data, here is the STUFF() version.

WITH cte
AS (SELECT *
    FROM
    (
       ...

Which tools and what sort of data?

Thanks, Jeff, I should have checked that!

You also need to install SSDT for VS 2017 (standalone installer).

Well spotted!

OK, what is the datatype of [DatesInYear].date_1?

What is the error message you receive?

Maybe like this:

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    Name VARCHAR(50)
   ,Value VARCHAR(50)
);

INSERT #SomeData
(
    Name
   ,Value
)
VALUES
('A', 'X')
,('A',...