Return multiple XML Data by Row or delimit | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Return multiple XML Data by Row or delimit

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.
]]>