I'm using this code for creating and xml file out of a SQL2005 table:
from ProductsInfo_ZAP p
for xml path('PRODUCT'),TYPE, ROOT('PRODUCTS')
) for xml path(''), ROOT('STORE')
Is there a way for me to create multiple xml files, one for every row, going by the primary key column, or do I have to create a separate query for each row?
I would also wondering what is the syntax for transforming this query into a stored procedure
View Complete Post