Posted by John Bell on 12/30/06 17:08

Hi Erland

> Also, the PIVOT query you posted, will not work for Nassa because he/she
> uses ntext which cannot be used with PIVOT. I see in your tables that
> you use nvarchar(MAX), but I tried yesterday in
> microsoft.public.sqlserver.programming to convince Nassa to use
> nvarchar(MAX) instead, but he/she did not even comment on it.
>
I would hope that a lack of comment would not mean that Nassa was opposed to
using this new feature, which would probably be more benificial than using
PIVOT.

I would hope that the design was not restricted to a single number for a
given type of number e.g. multiple mobile numbers, which would show that all
the methods have their limitations.

Neither of us suggested doing this on the client, which is still probably
the best place to do this regardless of SQL Server's capability.

John

[Back to original message]