Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Select\s+statement\s+using\s+last\s+month\'s\s+summary\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Select\s+statement\s+using\s+last\s+month\'s\s+summary\s*$/: 3 ]

Total 3 documents matching your query.

1. Select statement using last month's summary (score: 1): Author: Shannon Bach <SBach AT MGE DOT COM>; Date: Mon, 10 Mar 2003 09:40:35 -0600; The following select was pulled from this list; /* */ select case when SUM(BYTES) IS NOT NULL then CAST(SUM(BYTES) AS - DEC(40,2))/(1024*1024*1024) else ABS(CAST((0) AS - DEC(40,2))) end AS "Total Gi; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-03/msg00437.html (10,973 bytes)
2. Re: Select statement using last month's summary (score: 1): Author: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>; Date: Mon, 10 Mar 2003 10:50:19 -0600; Ok, this is my guess. ... /* */ select case when SUM(BYTES) IS NOT NULL then CAST(SUM(BYTES) AS - DEC(40,2))/(1024*1024*1024) else ABS(CAST((0) AS - DEC(40,2))) end AS "Total Gigabytes" from summary; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-03/msg00445.html (12,185 bytes)
3. Re: Select statement using last month's summary (score: 1): Author: Shannon Bach <SBach AT MGE DOT COM>; Date: Mon, 10 Mar 2003 12:12:42 -0600; Thanks Jack! It worked great! I was able to go back 31days as that is how much summary log that I keep. Normally, I have a script which runs in my morning process that sends a daily summary of GB's b; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-03/msg00448.html (11,269 bytes)

Current List: 1 - 3
Page: [1]