I have created a successful and properly formatted itunes RSS XML Feed for podcasting, however i wanted to clean up the XML Namespace appearing more than once.
Here is the basic T-SQL for my statement:
WITH XMLNAMESPACES ('http://www.itunes.com/dtds/podcast-1.0.dtd' as itunes)
SELECT '2.0' AS '@version',
(SELECT ............
(SELECT..........
FROM sqltablename1 for xml path ('item'), TYPE
) FOR XML PATH('channel'), TYPE
)
FOR XML PATH('rss')