none
XML query

    Question

  • I have a SQL query which returns more than 100 records.  I need to put the results in XML format.
    EX:
    <Deposits>
       <Deposits>
            <ID>45hlkl0094-lkjjf-809kjk<ID>
            <CheckDt>20100101<CheckDt>
            <CheckNum>145899<Checknum>
            <ID>98098jkkk-2384-238488<ID>
            <CheckDt>20100202<CheckDt>
            <CheckNum>234098<CheckNum>
           .......and this way it should go for all the records
       </Deposits>
    </Deposits>

    I need to store this in a file.  How to do this.
    Thanks.
    NSG12
    Thursday, February 25, 2010 11:15 PM

Answers

All replies