Thanks for the reply!

Here is what I have been working with today.

DECLARE

@StartDate DATETIME = NULL

,@EndDate DATETIME = NULL

SET @StartDate = '2011-08-01'

SET @EndDate = '2011-08-31'

SELECT

pnl.monthdate

,customer.custCode

,cust.Revenue

,pnl.NetRevenue

,pnl.NetRevenue -...