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',...

Without knowing how the underlying tables are structured, it's impossible to provide a coded answer. However, I suspect a combination of STRING_AGG() and GROUP BY should get you there. Some...

Indeed. I use localhost for my SQL server connections while developing and that is what gets checked in.

After deploying to another server, it is straightforward (once you know what you...

Do you mean switching from not...

Something like this?

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    Category VARCHAR(50)
   ,SomeDate DATETIME
);

INSERT #SomeData
(
    Category
   ,SomeDate
)
VALUES
('A', '20171231')
,('A',...