Posted by Tony Rogerson on 12/06/05 10:12

Its SQL Server 2005 only - are you using 2005?

Tony

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"bika" <aesahab@gmail.com> wrote in message
news:1133827068.526744.68480@g14g2000cwa.googlegroups.com...
> Thanks for the great ideas everyone.
>
> Tony,
> I tried to implement your code but every time I get an error msg, it
> doesn't accept elements after "FOR XML"
>

[Back to original message]