I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'. I want to be able to return list of all WOCode that...

It would be helpful to know what the higher and lower versions of SQL Server are.

Note that you could use SSIS to move data from database A to database B...

Are there any temp tables...

'failing to execute correctly' is not detailed enough for people to help. Please elucidate … is there an error message?

I think it's actually an en dash, not that it makes any difference to the point you're making!

How will anyone or anything be able to read such a file, if everything is jumbled together and the columns are not in fixed positions?

You should know how to post consumable data by now, with >5,000 points.

We can't run your code unless you provide supporting DDL. But you should know that too.

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