SQL Server create grand total row
<p>I have a table that contains order details.  How can I create a row at the end that totals all my subtotals?</p>

<pre><code>SELECT 
    o.order_id, o.itemDescription as Description, 
    o.quantity_shipped as [Quantity], 
    o.itemCost as [Price each], 
    (o.quantity_shipped * CAST(o.itemCost as float)) as [Sub Total] 
FROM 
    dbo.order_items o
</code></pre>