
March 25th, 2004, 07:14 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Case statement
Can someone please help with this case statement?
Case substr(cc.prname,1,5)
when 'Expense' then
case substr(p.name,1,5)
when 'Admin' then SUM(DECODE(ts.prstatus,4,(NVL (te.practsum,0)/3600),0)) admin_posted_hours,
when 'Maint' then SUM(DECODE(ts.prstatus,4,(NVL(te.practsum,0)/3600),0)) maint_posted_hours
else SUM(DECODE(ts.prstatus,4,(NVL(te.practsum,0)/3600),0)) proj_expense_posted_hours
end
when 'Capital' then SUM(DECODE(ts.prstatus,4,(NVL(te.practsum,0)/3600),0)) capital_posted_hours
when 'Margin' then SUM(DECODE(ts.prstatus,4,(NVL(te.practsum,0)/3600),0)) margin_posted_hours
else
SUM(DECODE(ts.prstatus,4,(NVL(te.practsum,0)/3600),0)) actual_posted_hours
end
|