emailhelen@g... wrote:

> I am in fact using SQL Server 2005. I would love to know how to handle
> this best through the SQL server. If you think XSLT would be a better
> option I would love to hear about that as well. I am afraid I am quite
> a newbie when it comes to this. Thanks again for your anticipated
> assistance!

With MS SQL Server you can use the FOR XML clause in SELECT statements 
to generate XML directly. With SQL Server 2005 you have the powerful FOR 
XML PATH, see your local SQL Server documentation or this section on MSDN:
http://msdn.microsoft.com/en-us/library/ms189885(SQL.90).aspx

If you need help then post your table structures, some sample data and 
the XML you want to generate from that sample data, then we can try to 
help you with the FOR XML PATH. You might however better do that in 
microsoft.public.sqlserver.xml as it is more likely that someone with 
skills in T-SQL and FOR XML reads that than here.

-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/