sql server 2000 query - for xml output

• sonwane.pratibha

  SSC Journeyman

  Points: 88

  More actions

  June 25, 2012 at 6:13 am

  #271688

  SELECT

  (

  SELECT [ExtID], [Name]

  FROM @tempBrand

  FOR XML PATH('Brand'),ROOT('Brands'), TYPE

  ),

  (

  SELECT [ExtID] , [Name] ,[CategoryPageUrl]

  FROM @tempCategory

  FOR XML PATH('Category'),ROOT('Categories'), TYPE

  )

  FOR XML PATH('Feed'),TYPE

  How to write above query in sql server 2000 ?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  June 25, 2012 at 6:38 am

  #1505017

  I haven't worked with SQL 2000 in a while, but here's something that might help:

  http://www.databasejournal.com/features/mssql/article.php/2196461/XML-and-SQL-2000-Part-1.htm

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon