XML Fragment.sql

DECLARE @Example XML ; SET @Example = '<SalesOrder OrderDate="2013-03-07" CustomerID="57" OrderID="3168"> <LineItem StockItemID="176" Quantity="5" UnitPrice="240.00" /> <LineItem StockItemID="143" Quantity="108" UnitPrice="18.00" /> <LineItem StockItemID="136" Quantity="3" UnitPrice="32.00" /> <LineItem StockItemID="92" Quantity="48" UnitPrice="18.00" /> </SalesOrder> <SalesOrder OrderDate="2013-03-22" CustomerID="57" OrderID="4107"> <LineItem StockItemID="153" Quantity="40" UnitPrice="4.50" /> <LineItem StockItemID="36" Quantity="9" UnitPrice="13.00" /> <LineItem StockItemID="208" Quantity="108" UnitPrice="2.70" /> </SalesOrder>' ; SELECT @Example ;