![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Thu, Feb 26 2009 11:54 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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. ![]() | 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 ![]() | Tim
That's what I was guessing so I'll stick with dear old Delphi. Roy Lambert |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |