SQL Server Performance

Return multiple XML Data by Row or delimit

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by dbernett, Mar 20, 2006.

  1. dbernett New Member

    I#%92m working with SQL 2005 and the new T-SQL for XML.

    Does anyone know how to return the “multiple” values with some kind of delimiter or return them by Rows? Below is my Query. Currently I get 10 ASIN numbers on a single row seperated by a space.

    Select top 1

    XMLData.query('declare default element namespace "http://webservices.amazon.com/AWSECommerceService/2004-11-10"; data(/ItemSearchResponse/Items/Item/ASIN)') ASIN

    From XMLDATA

    Thank you.

Share This Page