So, just to confirm, if we added the following row to your sample data

('A', 202208,50)

you would still wish to generate the

('B',202208,0)

row?

Yes, my initial solution was not correct, which I realised after re-reading your post.

You have Data items A, B and C all happening on different yearwks. Will that always be the case, or could you have overlapping data items, eg

('A',202201,10) and ('B',202201,20)

?

• This reply was modified 3 years, 3 months ago by Phil Parkin.
• This reply was modified 3 years, 3 months ago by Phil Parkin.

Please see this link – it may help you get past these errors.

Still no question.

You are seeing this error locally in SSDT, on the server, or both? Is this the same server that was running 2017, or a new server?

What is your question?

I don't think there is any chance of finding something like this. C# and VB.NET are functionally equivalent, Excel and SQL Server are not.

A manual rewrite is required.

@jeffwilliams "It looks like you put a DISTINCT on every single statement - which either means a bad join or bad design." What will you recommend here or how...

You should get into the habit of using 'YYYYMMDD' as your literal date format. This format is unambiguous and works regardless of which 'DATEFORMAT' is in place.

Regarding your question, your...

Are you sure it's the driver causing the issue, rather than the deprecated TLS protocol? You should probably be aiming to use TLS 1.2.

I suggest that you use a SQL query as the source for your dataflow, with output to a single column. Something like this:

DROP TABLE IF EXISTS #Place;

CREATE...

Is this a blog post, or do you have a question?

This is a very long post containing precisely zero questions.

Vetting such code is a job for a paid consultant.

To generate such a script, launch SSDT and select Tools/SQL Server/New Schema Comparison.

Select your source and target databases.

Go into Settings and select only Indexes.

Run the comparison and script out the...