A combination of DATEDIFF() and LAG() will get this done for you. If you are prepared to produce your sample data in consumable format (ie, in the form of CREATE...

Timing is everything. I have a similar project except it uses flat files with header and detail records. My problem was that the header would not get saved before...

How about providing an actual execution plan and asking for optimisation help?

I can't see how a FOR XML PATH solution (I assume that's what "stuff for xml" means) would be...

So close! Add a step after the Excel file is generated which renames it to something meaningful – Invoices_z.xlsx, where 'z' represents the InvoiceId, for example.

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 ago by Phil Parkin.
• This reply was modified 3 years 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.