Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Return XML from SQL Server with particular format RE: Return XML from SQL Server with particular format

  • June 30, 2016 at 12:07 am

    #1887778

    Hi,

    When i executed this with my query, It is giving me the following output:

    <Reports>

    <Report>

    <Header>

    <PrintedDate></PrintedDate>

    <PrintedBy></PrintedBy>

    </Header>

    <Footer>

    <DocumentPreparedBy></DocumentPreparedBy>

    </Footer>

    <Report>

    <Name>CECILIA</Name>

    <UserName></UserName>

    <Remarks></Remarks>

    <IPAddress>121.121.15.250</IPAddress>

    <DateCreated>2016-05-20T11:15:05.420</DateCreated>

    <AppID>BOS</AppID>

    <AppVersion>0.0.7.0</AppVersion>

    <LastLoggedin>2016-06-30T11:49:01.053</LastLoggedin>

    </Report>

    </Report>

    <Report>

    <Header>

    <PrintedDate></PrintedDate>

    <PrintedBy></PrintedBy>

    </Header>

    <Footer>

    <DocumentPreparedBy></DocumentPreparedBy>

    </Footer>

    <Report>

    <Name>CECILIA</Name>

    <UserName></UserName>

    <Remarks></Remarks>

    <IPAddress>121.121.15.250</IPAddress>

    <DateCreated>2016-06-01T11:43:19.480</DateCreated>

    <AppID>BOS</AppID>

    <AppVersion>0.0.7.0</AppVersion>

    <LastLoggedin>2016-06-30T11:49:01.053</LastLoggedin>

    </Report>

    </Report>

    </Reports>

    DO you want me to post my query? PLease let me know