Can anyone help with this?

-----Original Message-----
From: Raman Seeni
[mailto:mssqldba-ezmlmshield-x45512605.[Email address protected]
Sent: 31 July 2007 12:00
To: LazyDBA Discussion
Subject: for xml

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.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





MS Sql Server LazyDBA home page