A typical customer would be a small production company where in the past a consultant simply developed on one of the servers within the clients network. Back then it...

In SSMS, you can right-click on any database in the 'Object Explorer' window and get Properties. Within the Properties window, there is a Files node - click on that and...

Not that I know of.

If you have

SELECT x / y

and y is zero, that is an error. There is no solution as such, only a choice about what you would like to return in...

You appear to be suggesting that there is a standard format for AML files ... which is fine, but the number of people here who know both how to import...

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 2 months, 3 weeks 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...