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

• Next in forum: Re: Indexing and Queries
• Prev in forum: Re: Query Optimization: CPU speed or Logical Reads better?
• Thread view: Re: Getting data from multiple rows into one column

[Reply to this message]