Hi Gurus,

I am using SQL2000 SP3

I have the data for xml from the following query

SELECT KeyNumber, Agency, Advertiser, Title, Product, Duration,
AspectRatio
FROM TVC where KeyNumber=2

Now I would like to create an xml file named 2.xml in the following
format

<Adstream>
<Booking>
<ClockNumber>2</ClockNumber>
<Agency>Agency1</Agency>
<Advertiser>Advertiser1</Advertiser>
<Title></Title>
<Product>Product1</Product>
<Duration>40</Duration>
<AspectRatio>16:9</AspectRatio>
</Booking>
</Adstream>

Please help me.


MS Sql Server LazyDBA home page