For XML RAW

• lav-888385

  SSC-Addicted

  Points: 455

  More actions

  November 16, 2010 at 1:52 am

  #228806

  Hi,

  How to use For XML RAW in Sub query or derived table using Sql Server 2000

  For eg.

  select * from

  (

  select ALLOC_REF,Entity from

  #alloc for xml raw

  )b

  Thanks

  Lav

• Tim Parker

  SSCommitted

  Points: 1644

  More actions

  November 16, 2010 at 9:41 am

  #1251429

  Lav,

  You may need to provide some more information on how you plan to use the subquery or derived table.

  Based on what you provided, I would suggest moving the FOR XML RAW statement outside of the subquery.

  If you need more info use BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/3828b4ca-3ab2-444f-9c58-8be6e7f064a6.htm

  😀

• lav-888385

  SSC-Addicted

  Points: 455

  More actions

  November 16, 2010 at 11:22 pm

  #1251693

  Hi,

  I want to concatinate a BillDate separated by comma ALLOc_REF and Entity group wise.

  FOR Eg.

  Table structure:

  ENTITY ALLOC_REF BILLDATE

  AB04/01/2010

  AB04/02/2010

  BB05/01/2010

  O/P:

  A B 04/01/2010,04/02/2010

  B B 05/01/2010