SELECT othercolumns...,
Trans_Sym_Desc = case 
when Trans_Sym = 1 then 'Paved Road'
when Trans_Sym = 2 then 'Unpaved Road'
when Trans_Sym = 3 then 'Surface Unknown Road'
when Trans_Sym = 4 then 'Abandoned Road'
when Trans_Sym = 5 then 'Orphaned Road'
when Trans_Sym = 6 then 'Railroad'
when Trans_Sym = 7 then 'Railroad Grade'
when Trans_Sym = 8 then 'Trail'
when Trans_Sym = 9 then 'Ferry Crossings'
end
FROM
(
SELECT othercolumns....,
Trans_Sym = case 
when A.trans_rte_ty = 10 and B.road_act_stat_cd in (10,20,99) and F.road_sur_ty = 1 then 1
when A.trans_rte_ty = 10 and B.road_act_stat_cd in (10,20,99) and F.road_sur_ty in (2,3,4,5) then 2
when A.trans_rte_ty = 10 and B.road_act_stat_cd in (10,20,99) and F.road_sur_ty = 9 then 3
when A.trans_rte_ty = 10 and B.road_act_stat_cd = 30 then 4
when A.trans_rte_ty = 10 and B.road_act_stat_cd = 40 then 5
when A.trans_rte_ty = 30 then 6
when A.trans_rte_ty = 31 then 7
when A.trans_rte_ty = 20 then 8
when A.trans_rte_ty = 50 then 9
end
FROM .....
.........
)t

quote:

---

Originally posted by mayurgogia

Hello Visakh....
I guess you have given the right thing to do but this could not help me a lot. Can you please write complete query. No need of other columns. Just required ones will work.

Mayur Gogia

---