Prove to the client that the zeros are there. Do not use Excel as a data import tool, it messes with the data before you even see it.

MySQL and SQL Server are not the same thing. The script you have provided looks like a SQL Server script, so if you are attempting to run it in MySQL,...

Just a quick question: are you opening the .CSV in a text editor (eg, Notepad ++)?

If you open it in Excel, Excel will 'helpfully' guess the datatype to be int...

I imagine you already searched the Internet before posting, but this looks like it might work

https://stackoverflow.com/questions/46808818/how-to-repeat-header-rows-for-each-group-within-the-same-page-in-ssrs-2008

As long as the datatype of the SSN remains as string throughout the export, this should not be happening.

Somewhere in your process, it is being treated as an INT and...

Is a pop up you're getting with the first post? I don't know I've seen a "are you sure" message.

I do get the frustration with a timeout or error...

Sounds like you need to implement dynamic grouping within the report. I've never tried to do that, so I'm not sure whether it's even possible.

Alternatively, if your report is calling...

Adding DISTINCT would make it 20 rows.

Why does your codes table contain duplicates?

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

Like this? Returns 21 rows, so maybe not quite!

SELECT *
FROM #Codes c
WHERE EXISTS
(
    SELECT 1 FROM #Data d WHERE d.Standard = c.Standard
);

Okay, let me rephrase the question: What in you opinion should then be installed on that client (the one RDP'ed against) to get a workable development setup?

And yes, in...

Don't think so. The customer would be  100 miles around the block and the solution and data itself only existed on the customers server.

No other option than to set...

Yes, of course.

In fact I would say that you've been going against best practice for those 15 years.

Developing locally with VS and SQL Server and then checking in your changes...

We do need some more information here.

While you have provided your desired output, can you also provide the input data corresponding with that desired output, so that someone here can...

I don't know how much it matters, because I always make sure my version of VS is at least as high as the version of SQL Server I am deploying...

Are you editing the SSIS project in VS2022?

Have you set TargetServerVersion to SQL Server 2022 in the project's properties?

Have you taken the 'Upgrade All Packages' option to make sure they're...