DECLARE @x XML
SET @x = '
<salesOrder orderNumber="100001" customerNumber="JAC001" orderDate="01-01-2007">
  <lineItems>
    <item itemNumber="A001" qty="10" rate="10.5" />
    <item itemNumber="A002" qty="20" rate="11" />
    <item itemNumber="A003" qty="30" rate="13" />
  </lineItems>
</salesOrder>'

SELECT 
	x.header.value('@orderNumber[1]', 'varchar(20)') AS OrderNumber,
	x.header.value('@customerNumber[1]', 'varchar(20)') AS CustomerNumber,
	x.header.value('@orderDate[1]', 'datetime') AS OrderDate
FROM @x.nodes('//salesOrder') AS x(header)