Convertir un XML a una Tabla en SQL Server 2008

declare @mydoc xml set @mydoc='<Orders>  <Order OrderID="13000" CustomerID="ALFKI" OrderDate="2006-09-20Z" EmployeeID="2"> </Order>  <Order OrderID="13001" CustomerID="VINET" OrderDate="2006-09-20Z" EmployeeID="1"> </Order> </Orders>' SELECT OrderID    = T.Item.value('@OrderID', 'int'),       CustomerID = T.Item.value('@CustomerID', 'nchar(5)'),       OrderDate  = T.Item.value('@OrderDate',  'datetime'),       EmployeeId = T.Item.value('@EmployeeID', 'smallint') FROM   @mydoc.nodes('Orders/Order') AS T(Item)