Thank you for the response, Steve.

I have tracked down the problem – for testing purposes, a database restore had been performed, from a database with CT enabled. Nothing was consuming...

Hi Steve, sorry for the slow reply.

One of the database sources is SQL Server 2022, CU22, with DB at compatibility level 100.

Another is an Azure SQL database which is running...

Sure there is. In your Excel source, define a suitable sheet name and range, eg

Sheet1$A1:H21

I wish you'd asked me at the time, as my medium-term memory only works for a few hours these days!

What I think happened was I tried to create a detailed...

Is that this Dev Express?

https://docs.devexpress.com/WindowsForms/2141/common-features/formatting-values/format-specifiers

It seems to have a comprehensive formatting capability.

As I am running exactly the same version of SQL Server as you, I can only conclude that your query settings must somehow be affecting the result. Not sure I...

This is the code I ran. Can you confirm that it produces inconsistent results on your system?

SELECT @@VERSION
 
SELECT '1.' Id
UNION ALL
SELECT '1-' Id
ORDER BY Id
 
SELECT...

Interestingly, using only VARCHAR produces consistent results. Not sure why Unicode characters are working differently.

My e-mail notifications (except for the newsletter) stopped working at the end of June. But it seems the problem is resolved now.

I'm going to attempt to post a 64-line script I first posted as a response in a thread months ago, as a SQL code block.

DROP TABLE IF...

Something has changed in the last week or so. For months, I have not been receiving any notifications of new topics or replies to my posts, but a few days...

I still don't really understand what you are trying to achieve.

You have a database on server A. Users can access some tables and execute some procs.

You restore the database to...

Can you go into a bit more detail regarding this 'ownership chain' you are trying to prevent?

I'm a fan of the flexibility of tablixes (tablices?) but one thing I find really awkward/annoying about them is when saving as XLS, you inevitably end up with merged...

I learned Git by working with it. There is a lot going on & I can sympathise if you're feeling overwhelmed.

Jump in and try the following

• Create a 'Database' repo...