Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Extracting stats |
Thu, Feb 26 2009 11:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Feb 27 2009 8:18 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Feb 27 2009 9:30 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
That's what I was guessing so I'll stick with dear old Delphi. Roy Lambert |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |