SQL SERVER - shan

I have created an XML file in SQL server 2000. I need to store this filed under a folder as an XML file. Following is the code structure.



CREATE PROCEDURE [sp_TestXML2]

@XMLOUT		varchar(8000)		OUTPUT		-- this time use an output parameter



AS

DECLARE

@XML 		varchar(8000),

@strRow			varchar(50),

@RowId			int,

@Rowcount		int



Begin --Main



SELECT @Rowcount = count(*) FROM SNP_ORS_Table_Create_XML(NOLOCK)

SET @XML = '<?xml version="1.0" encoding="UTF-8" ?>'

SET @XML = @XML + '<tma>'

SET @XML = @XML + '<tma_header>'

SET @XML = @XML + '<conversationid></conversationid>'

SET @XML = @XML + '<transaction>TRAN29D</transaction>'

SET @XML = @XML + '<sourcecountry>XXXX</sourcecountry>'

SET @XML = @XML + '<sourcecompany>YYYYY</sourcecompany>'

SET @XML = @XML + '<sourcesystem>ZZZZ</sourcesystem>'

SET @XML = @XML + '</tma_header>'

SET @XML = @XML + '<tma_body>'

SET @XML = @XML + '<bankfiletype>NB</bankfiletype>'

SET @XML = @XML + '<generateddate>28-Nov-07</generateddate>'

SET @XML = @XML + '<records>'

While (@Rowcount > 0)

BEGIN

Set Rowcount  1

Select @RowId = recId,@strRow = record From SNP_ORS_Table_Create_XML(NOLOCK)

SET @XML = @XML + '<record>' + LTRIM(RTRIM(@strRow)) + '</record>'

Delete From SNP_ORS_Table_Create_XML Where recId = @RowId

Set @Rowcount = @Rowcount-1

END

SET @XML = @XML + '</records>'

SET @XML = @XML + '</tma_body>'

SET @XML = @XML + '<tma_fault>'

SET @XML = @XML + '<systemfault/>'

SET @XML = @XML + '<applicationfault/>'

SET @XML = @XML + '</tma_fault>'

SET @XML = @XML + '</tma>'

-- output the xml as a single parameter

SELECT @XMLOUT = LTRIM(RTRIM(@XML))

End --Main



I need to store @XML as an xml file under any folder. Please help