I tried the comma-before + stuff approach.

That's what I remembered, but couldn't reproduce.

But, it has a problem: there is a space before the comma.

The result looks like

[font="Courier New"]NameID Name...

The trick is in the article Graig mentioned. I needed some time to find it.

The [font="Courier New"]as 'data()'[/font] addition gives the result without the <...>-parts:

[font="Courier New"]select...

@Craig, thank you for the article, I'am a noob on XML, so it gives me the background to understand what I'am doing.

@GSquared, I tryed your Sql-code,...

Willem,

Thank you for your answer.

Ad 1.

I tried to change Text -> Varchar(max) in a copy of the database and found out the data are unchanged. So far so good.

I have...

I didn't give a low rating, but found a...

Sorry Jeff, it's not possible. 🙁

The problem comes from a complex SP a college was developing for...

@lowell & garadin

The combination of your tips did the trick. 🙂

Problem solved.

Thank you. 😎

Sorry, the table is a "not owned by myself".

So I can't convert the NText column to a NVarchar(max).

And the 'large value types out of row' is set to off. So...

I Updated the Intel 82915G driver (from the year 2004) to the latest version (2007).

And now is "Open Table"...

Thanks Henrico,

I am a developer, not a DBA, that's why I didn't know what a BPA stands for 😉

Sorry, I don't know what you mean by BPA, please could you explain?

@ sql_lock:

Thank you for your suggestion.

I'll try to update to the latest graphics driver.

@Henrico.

I tried a another resolution: 16 bits in stead of 32 bits. Maybe it's a bit faster, but still very slow. :crying:

@ian.

You are right, the OR solution works. :blush:

All of you, thanks.

Sorry a crosspost.

@david-2 THANKS, that's where I was looking for.

Performance is no problem, because the max amount of records is 50.

(trainees needed, shown on the internet, divided in...