XML : Converting multiple rows to single XML row. - SQL Server

I have one table in following format. enter image description here

I want data in XML format per Employee as below

  <Employee>    <EmployeeID>1</EmployeeID>    <FirstName>Jon</FirstName>    <LastName>Snow</LastName>    <City>North of the wall</City>    <Age>28</Age>    <Gender>Male</Male>  </Employee>    <Employee>    <EmployeeID>2</EmployeeID>    <FirstName>Arya</FirstName>    <LastName>Stark</LastName>    <City>Winterfell</City>    <Age>14</Age>    <Gender>Female</Male>  </Employee>    

No comments:

Post a Comment