SELECT CAST( (SELECT * FROM Orders JOIN [Order Details] AS Detail ON Orders.OrderID = Detail.OrderID WHERE Detail.OrderID IN (SELECT od.OrderID FROM [Order Details] AS od GROUP BY od.OrderID HAVING SUM(od.Quantity * od.UnitPrice) > 15000) FOR XML AUTO, ROOT('Orders') ) AS XML) AS Data INTO XMLOrders SELECT * FROM XMLOrders