SQL Server Performance

got any tool for this function ?

Discussion in 'Third Party Tools' started by abhinay1983, Feb 15, 2005.

  1. abhinay1983 New Member

    Hi Guys,
    would like to know if any software can do the following.
    1) the software should run a query automatically (the query can be changed), on a particular day or on every day at a particular time.
    2) The data should be outputted to xml format(requirement) and it should be configurable to export to other formats (optional)
    Another important requirement is that the xml format should be like the below.

    <XMLIntegration>File Creation Timestamp
    <Load COLUMNS="Area, Date, keyval, value">
    England, 08/01/2005, 1, 1950
    England, 08/01/2005, 2, 2010
    England, 08/01/2005, 3, 2020
    England, 08/01/2005, 4, 2030
    England, 08/01/2005, 5, 2076
    …
    …
    …
    …
    </ Load >
    </XMLIntegration>

    which means that all the data generated from the query is not in general xml format, but it should be like the above format

    Even if the software is a costly one, please let me know. Thank You

    Regards,
    Abhi
  2. satya Moderator

Share This Page