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

You want to generate a single data item which (somehow) combines both Category and Date, is that correct?

What form should this composite value take?

Something like

XXnnnnnn,

where XX is a code for...

Thanks for posting the second link, Frederico. That is a useful technique.

What exactly do you mean by 'flip'?

Yes, I have sensitive parameters assigned from SSISDB, but I think you must mean something more involved than that.

From the top of my head, some pros are as follows:

1. Comprehensive execution logging, with built-in reports, is available to you as a 'freebie'. No additional config required.
2. The ability...

One big con depending on what version you are doing is that in Project mode deployment of individual packages isn't possible.  You have to deploy the entire project.  This...

Keywords indeed! OK, here is one way, which (for ordering purposes) relies on every person having a unique Id column.

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
 ...

Never seen this function before!

Having said that, if you can transform your source query so that the results look like this, it would be straightforward.