SweNz

create TABLE CustomerInfo
( data XML);

-------------------------------

insert INTO CustomerInfo
        ( data )
VALUES  ( CAST('<ArrayOfCustomerInfo  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">
  <Customer CustCode="001">
    <CustName>John</CustName>
    <Queues>
      <Q>
        <No>3</No>
        <Line>1</Line>
      </Q>
    </Queues>
  </Customer>
  <Customer CustCode="035">
    <CustName>Chris</CustName>
    <Queues>
      <Q>
        <No>10</No>
        <Line>1</Line>
      </Q>
    </Queues>
  </Customer>
  </ArrayOfCustomerInfo>' AS XML)
          );

--------------------------------------------------------------------------------------------------

SELECT a.b.value('@CustCode','varchar(4)') AS Code
       ,a.b.value('CustName[1]','varchar(20)') AS Name
       ,c.d.value('No[1]','int') AS QNo
       ,c.d.value('(Line)[1]','int') AS QLine
FROM  PGHRMS_Employees x
CROSS APPLY x.data.nodes('/ArrayOfCustomerInfo/Customer') AS a(b)
CROSS APPLY a.b.nodes('Queues/Q') AS c(d)