DECLARE @Data xml
set @Data = '<Data>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserRole</TABLE_NAME>
    <COLUMN_NAME>RoleId</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>int</DATA_TYPE>
    <NUMERIC_PRECISION>10</NUMERIC_PRECISION>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserRole</TABLE_NAME>
    <COLUMN_NAME>RoleName</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>100</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>100</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>UserAccountID</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>bigint</DATA_TYPE>
    <NUMERIC_PRECISION>19</NUMERIC_PRECISION>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>UserName</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>20</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>20</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>FullName</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>25</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>25</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>Password</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>50</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>50</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>CompanyID</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>bigint</DATA_TYPE>
    <NUMERIC_PRECISION>19</NUMERIC_PRECISION>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>CreatedDate</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>datetime</DATA_TYPE>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>UpdateDate</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>datetime</DATA_TYPE>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>RoleID</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>int</DATA_TYPE>
    <NUMERIC_PRECISION>10</NUMERIC_PRECISION>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>ResetPasswordKey</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>100</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>100</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Local</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>IsPasswordReset</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>bit</DATA_TYPE>
  </Table>
</Data>'

DECLARE @Data1 xml
set @Data1 ='<Data>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>UserAccountID</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>bigint</DATA_TYPE>
    <NUMERIC_PRECISION>19</NUMERIC_PRECISION>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>UserName</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>20</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>20</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>FullName</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>50</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>50</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>Password</COLUMN_NAME>
    <IS_NULLABLE>NO</IS_NULLABLE>
    <DATA_TYPE>varchar</DATA_TYPE>
    <CHARACTER_MAXIMUM_LENGTH>50</CHARACTER_MAXIMUM_LENGTH>
    <CHARACTER_OCTET_LENGTH>50</CHARACTER_OCTET_LENGTH>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>CompanyID</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>bigint</DATA_TYPE>
    <NUMERIC_PRECISION>19</NUMERIC_PRECISION>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>CreatedDate</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>datetime</DATA_TYPE>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>UpdateDate</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>datetime</DATA_TYPE>
  </Table>
  <Table>
    <TABLE_CATALOG>Employee_Live</TABLE_CATALOG>
    <TABLE_NAME>tblUserAccount</TABLE_NAME>
    <COLUMN_NAME>RoleID</COLUMN_NAME>
    <IS_NULLABLE>YES</IS_NULLABLE>
    <DATA_TYPE>int</DATA_TYPE>
    <NUMERIC_PRECISION>10</NUMERIC_PRECISION>
  </Table>
</Data>'

SELECT *
from
(
	SELECT	xmlobj.value('TABLE_NAME[1]','VARCHAR(500)') AS TABLE_NAME,
			xmlobj.value('COLUMN_NAME[1]','VARCHAR(500)') AS COLUMN_NAME,
			xmlobj.value('IS_NULLABLE[1]','VARCHAR(500)') AS IS_NULLABLE,
			xmlobj.value('DATA_TYPE[1]','VARCHAR(500)') AS DATA_TYPE,
			xmlobj.value('CHARACTER_MAXIMUM_LENGTH[1]','VARCHAR(500)') AS CHARACTER_MAXIMUM_LENGTH 	
	FROM @Data.nodes('//Table') as r (xmlobj)
	except
	SELECT	xmlobj.value('TABLE_NAME[1]','VARCHAR(500)') AS TABLE_NAME,
			xmlobj.value('COLUMN_NAME[1]','VARCHAR(500)') AS COLUMN_NAME,
			xmlobj.value('IS_NULLABLE[1]','VARCHAR(500)') AS IS_NULLABLE,
			xmlobj.value('DATA_TYPE[1]','VARCHAR(500)') AS DATA_TYPE,
			xmlobj.value('CHARACTER_MAXIMUM_LENGTH[1]','VARCHAR(500)') AS CHARACTER_MAXIMUM_LENGTH 	
	FROM @Data1.nodes('//Table') as r (xmlobj)
)t