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

Like you, Window functions and CTEs changed the way I write a lot of my T-SQL. DROP … IF EXISTS also makes code much tidier.

When they made Developer Edition free...

Despite this being the same error message as the original post, you should really start a new thread, as it's likely a different issue causing the same error.

You do not...