title: Dealing with XML datatype(SQL SERVER 2005)
body: <p>I have a table having 2 columns EmployeeId (int) and EmployeeDetails(XMl type)</p>
  
  <p>EmployeeId  EmployeeDetails</p>
  
  <p>1           &lt;Employee&gt;&lt;EmployeeDetails&gt;&lt;EmployeeName&gt; Priyanka &lt;/EmployeeName&gt;&lt;Age&gt; 24 &lt;/Age&gt;&lt;Address&gt; Argentina&lt;/Address&gt;&lt;/EmployeeDetails&gt;&lt;/Employee&gt;</p>
  
  <p>2   &lt;Employee&gt;&lt;EmployeeDetails&gt;&lt;EmployeeName&gt; Sarkar &lt;/EmployeeName&gt;&lt;Age&gt; 28 &lt;/Age&gt;&lt;Address&gt; Australia&lt;/Address&gt;&lt;/EmployeeDetails&gt;&lt;/Employee&gt;</p>
  
  <p>I need to have the output like</p>
  
  <p>EmployeeId          EmpName          Age            Address</p>
  
  <hr>
  
  <p>1                   Priyanka        24              Argentina</p>
  
  <p>2                    Sarkar         28              Australia</p>
  
  <p>Please help as I am new to xml</p>