declare @begindate char(10), @enddate char(10)
set nocount on
select @begindate = '01/01/2000'
select @enddate = '01/31/2000'
set nocount off
Select TaxID, Tax, Tax2, Description from taxes /* List TaxID and
Description */
Select "Taxes Invoiced Summary for Month of February 2000" /* Must Change
Mannually */
Select ii.TaxID, beforetax=sum(ii.amount*ii.quantity),
taxes=sum(ii.tax)+sum(ii.tax2),
total=sum(ii.amount*ii.quantity)+sum(ii.tax)+sum(ii.tax2)