Databases Reference
In-Depth Information
when year5 between (10547*&&pct_for_data) and (25804*&&pct_for_data)
then 'Half Rack'
when year5 between (25804*&&pct_for_data) and (51609*&&pct_for_data)
then 'Full Rack'
when year5 > (51609*&&pct_for_data) then 'Full Rack+'
end
when upper('&&asm_redundancy') = 'HIGH' then
case
when year5 < (7372*&&pct_for_data) then 'Quarter Rack'
when year5 between (7372*&&pct_for_data) and (17203*&&pct_for_data)
then 'Half Rack'
when year5 between (17203*&&pct_for_data) and (34406*&&pct_for_data)
then 'Full Rack'
when year5 > (34406*&&pct_for_data) then 'Full Rack+'
end
else
case
when year5 < (10547*&&pct_for_data) then 'Quarter Rack'
when year5 between (10547*&&pct_for_data) and (25804*&&pct_for_data)
then 'Half Rack'
when year5 between (25804*&&pct_for_data) and (51609*&&pct_for_data)
then 'Full Rack'
when year5 > (51609*&&pct_for_data) then 'Full Rack+'
end
end
when upper('&&hp_or_hc') = 'HC' then
case
when upper('&&asm_redundancy') = 'NORMAL' then
case
when year5 < (55296*&&pct_for_data) then 'Quarter Rack'
when year5 between (55296*&&pct_for_data) and (129024*&&pct_for_data)
then 'Half Rack'
when year5 between (129024*&&pct_for_data) and (258048*&&pct_for_data)
then 'Full Rack'
when year5 > (258048*&&pct_for_data) then 'Full Rack+'
end
when upper('&&asm_redundancy') = 'HIGH' then
case
when year5 < (36864*&&pct_for_data) then 'Quarter Rack'
when year5 between (36864*&&pct_for_data) and (86016*&&pct_for_data)
then 'Half Rack'
when year5 between (86016*&&pct_for_data) and (172032*&&pct_for_data)
then 'Full Rack'
when year5 > (172032*&&pct_for_data) then 'Full Rack+'
when year5 > (172032*&&pct_for_data) then 'Full Rack+'
end
else
case
when year5 < (55296*&&pct_for_data) then 'Quarter Rack'
when year5 between (55296*&&pct_for_data) and (129024*&&pct_for_data)
then 'Half Rack'
Search WWH ::
Custom Search