Re: [Emerald] project for the day

Kenneth Gustav Eitenmiller Jr ( keitenmiller@hughestech.net )
Mon, 7 Feb 2000 15:17:09 -0600

This is what I came up with...With help from Dale
If anyone knows of anyways to clean this up, Please let us know...
Ken

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)