select * from dbo.UW_VECHICLE_MAP where IE_VECHICLE_CODE=1250
IE_VECHICLE_CODE UW_VEHICLE_CODE VEHICLE_MAKE_CODE VEHICLE_MODEL_CODE VEHICLE_SUBTYPE_CODE UW_CODE 1250 38162413 110 7 72 6 1250 0 84 12769 0 11 1250 0 3803 MARUTI SUZUKI 0 9
select *,case when uw_code =6 Then 'bajaj' when uw_code =9 then 'tata' End as NewColumn from dbo.UW_VECHICLE_MAP where IE_VECHICLE_CODE=1250
select IE_VECHICLE_CODE,UW_VEHICLE_CODE,VEHICLE_MAKE_CODE,VEHICLE_MODEL_CODEVEHICLE_SUBTYPE_CODE, case when UW_CODE = 6 then 'bajaj' when UW_CODE = 9 then 'tata' end as Company from dbo.UW_VECHICLE_MAP where IE_VECHICLE_CODE=1250
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)