Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
2002-04-03 08:27:58
Subject: |
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS |
From: |
"Seay, Paul" <seay_pd AT NAPTHEON DOT COM> |
Date: |
Wed, 3 Apr 2002 08:27:09 -0500 |
select NodeName, sum(cast(cast(trim(substr(message,47,6)) as
decimal(10,3))*case when substr(message,54,2) = 'GB' THEN 1000 when
substr(message,54,2) = 'MB' THEN 1 when substr(message,54,2) = 'By' then
.001 end as decimal(10,0))) as "Megabytes" from actlog where msgno=4961 and
date_time >current_timestamp - 8 hours group by nodename
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, MC Matt Cooper (2838)
- Re: Need Help Controlling Script Output, Field Lengths, ADSM ADSMuser
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, Prather, Wanda
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, Seay, Paul
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, MC Matt Cooper (2838)
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS,
Seay, Paul <=
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, MC Matt Cooper (2838)
|
|
|