Anyone suggest a way to extract the last 30 days stats from a table (calls made, positive results, negative results) with zeros for those days where there are no stats. The info is stored in summary form so the table will be along the lines of:


date        made    positive    negative
01/02/09    32        12            20
04/02/09    120        8            39

and I'd like to get
date        made    positive    negative
01/02/09    32        12            20
02/02/09      0        0                0
03/02/09      0        0                0
04/02/09    120        8            39



Roy Lambert

Roy,

<< Anyone suggest a way to extract the last 30 days stats from a table
(calls made, positive results, negative results) with zeros for those days
where there are no stats. The info is stored in summary form so the table
will be along the lines of: >>

This will have to be a script or procedure since you'll have to use a
temporary table to generate the series of dates that will be joined to the
actual data table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


That's what I was guessing so I'll stick with dear old Delphi.

Roy Lambert