OK. The source is SQL Server and it's a simple query?

SELECT col = cast(x as VARCHAR(50)) FROM tab1

sort of thing?

What is the target? SQL Server, Excel, CSV, ...

Simple answer:...

They're called folders and what you suggest is now possible, even with just Pro, as far as I can see:

That's me told. My 6,000 points arise mainly from answering QotD, but apologies for supplying everything in the wrong order and in the wrong format.  I'll try to do...

Also inexpertly provided. In future, please help others by providing your data in consumable format ... ie, one which can be pasted straight into SSMS. With nearly 6,000 points, you...

Nice question, but how about also giving us some consumable sample data to test with?

Can you mock up two or three rows of source data, along with an idea of what the 'parsed' results will look like?

You mention having XML stored in SQL Server,...

Migrating your SSRS reports to Power BI Paginated reports is straightforward & sounds like a better solution to me. Or are you staying away from Power BI?

Not directly related, but if you migrate to VS2022, everything is 64-bit, putting an end to this kind of faffing about!

There certainly is, and it's called Source Control. You may have heard of 'Git' – that is one of the most popular source control tools in use right now.

Take a...

Mine also have '8' and they all seem to be working fine, so I think you're all set.

Thanks. Yes, that is the plan of course. I was just wondering if it was even necessary - could we rely on some setting external to the database to...

You've been here long enough to know that the protocol is to leave your original question intact and instead to post a response describing the resolution, in case this is...

Maybe have a setting somewhere which indicates whether to use UK, Australia or ROI.

Create a UDF to do the formatting which uses the environment setting. Change your code to use...