Generate XML from SQL 2000 tables

Hi,

I am a newbie to XML. I am trying to generate a customised format of XML document from SQL 2000 table. This document is something like an acknowledgment reply. Does it mean I have to create a table structure similar to the format of the XML document to facilitate the generation of the desired format?

Any kind souls, please help.

Thanks.Did you look into

FOR XML

Operator?|||In this case, am I correct to say I need to have a table structure that maps (which currently does not exist) to the hierarchy of the XML acknowledgement first. Pardon my ignorance. ;D
===================
Originally posted by Brett Kaiser
Did you look into

FOR XML

Operator?|||Try this in QA

USE Northwind
GO
SELECT * FROM Orders FOR XML AUTO
GO