MSSQL Output in XML using For XML « Naveen’s Weblog

MSSQL Output in XML using For XML « Naveen’s Weblog.

http://technet.microsoft.com/en-us/library/ms345137(SQL.90).aspx#forxml2k5_topic8