On Thu, Aug 4, 2011 at 10:35 PM, Leyne, Sean wrote:
>
>
>
> - Firebird databases generate at least (*1) 1 write operation per database
> transaction (even SELECT statements) since the current transaction number in
> the database header page must be written to disk. So, depending on the
> amount o
> are you sure you can live with data loss in cause of system- powersupply- or
> emergency-shutdown-errors?
> our database is about 42gb. that is the cause why we`re backing up just once
> a day. it has it`s own raid1-volume, and for performance reasons i am
> planning to add a raid5 with 4 fast
Thanks Marco and Iwan for your help. That did the trick
Mike
- Original Message -
From: Iwan Cahyadi Sugeng
To: firebird-support@yahoogroups.com
Sent: Thursday, August 04, 2011 11:12 AM
Subject: {Disarmed} Re: {Disarmed} Re: [firebird-support] How do I figure
what percentag
Try this, i think this is what he meant:
SELECT CS.ACCT_ID,
CS.CASE_ID,
CSD.ITEM_DESC,
CSD.ORIG_BAL_DUE,
CSD.SETTLEMENT_AMOUNT,
Case when CSD.ORIG_BAL_DUE > 0 then CSD.SETTLEMENT_AMOUNT /
CSD.ORIG_BAL_DUE else 0 end * 100.00 AS PERCENTAGE
FROM CASE_SETTLEMENT_DETAIL CSD
JOIN CASE_SETTLE
ur welcome,
I mean that u cant ask a computer to do something / zero
using CASE u can hevitate:
select .., CASE CSD.ORIG_BAL_DUE WHEN 0 THEN else
(CSD.SETTLEMENT_AMOUNT
/ CSD.ORIG_BAL_DUE) * 100.00) end AS PERCENTAGE
from
or filter them:
select from WHERE ( CSD.ORIG_BAL_D
Greeting Marco,
I think you may be right on the division by zero. Not sure what you mean by
"use CASE to check before division".
Could you please elaborate.
Thanks,
Mike
- Original Message -
From: "marco bianchini"
To:
Sent: Thursday, August 04, 2011 8:15 AM
Subject: Re: {Disarmed}
may be division by zero,
use CASE to check before division, and return something else if A = 0
2011/8/4 SoftTech
> **
>
>
> Hmm, common math, who knew :>) And seems simple enough but returns an error
> "arithmetic exception, numeric overflow, or string truncation"
>
> Adding "((CSD.SETTLEMENT_AM
Hmm, common math, who knew :>) And seems simple enough but returns an error
"arithmetic exception, numeric overflow, or string truncation"
Adding "((CSD.SETTLEMENT_AMOUNT / CSD.ORIG_BAL_DUE) * 100.00) AS PERCENTAGE" to
the SQL statement below creates the error.
Both SETTLEMENT_AMOUNT and ORIG_
> Firebird 1.5.3
>
> Is it possible to return a percentage of the following within a stored
> procedure?
>
> Value A = $1000.00
> Value B = $600.00
>
> Result C = 60%
(B / A) * 100
;-)
--
With regards,
Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thom
Greetings All,
Firebird 1.5.3
Is it possible to return a percentage of the following within a stored
procedure?
Value A = $1000.00
Value B = $600.00
Result C = 60%
I'm looking for some formula to return Result C.
Any tips appreciated.
Thanks,
Mike
> Alexandre Benson Smith wrote:
>>From the Geoff post the only conclusion for me is... The guy
>> used the wrong product, and standard virtualization is not
>> suitable for production environment.
>
> I can't really agree with such a sweeping statement. It all
> depends on what your "produ
Alexandre Benson Smith wrote:
> From the Geoff post the only conclusion for me is... The guy
> used the wrong product, and standard virtualization is not
> suitable for production environment.
I can't really agree with such a sweeping statement. It all
depends on what your "production environm
Den 2011-08-04 09:11 skrev Lester Caine såhär:
> Kjell Rilbe wrote:
>> Yes, maybe. Could you give any stats on performance with such a setup
>> compared to regular RAID 1 with traditional 15 krpm scsi disks?
>
> Also worth considering although may not be practical if you don't manage the
> hardware
Kjell Rilbe wrote:
> Yes, maybe. Could you give any stats on performance with such a setup
> compared to regular RAID 1 with traditional 15 krpm scsi disks?
Also worth considering although may not be practical if you don't manage the
hardware, Solid State Disks prices are coming down ...
In my ow
14 matches
Mail list logo
