i need to drop columns which has value '0' in both the rows
select DateString as 'Date',machine,
sum (case when vfrm.job_id = '105' then (total_hours) else '0' end)as A,
sum (case when vfrm.job_id = '100' then (total_hours) else '0' end) as B,
sum (case when vfrm.job_id = '101' then (total_hours) else '0' end) as C,
sum (case when vfrm.job_id = '102' then (total_hours) else '0' end) as D,
sum (case when vfrm.job_id = '103' then (total_hours) else '0' end) as E,
sum (case when vfrm.job_id = '134' then (total_hours) else '0' end) as F,
sum (case when vfrm.job_id = '135' then (total_hours) else '0' end) as G ,
sum (case when vfrm.job_id = '9995' then (total_hours) else '0' end) as OTHERS
from ven_fullreportmaster vfrm
INNER JOIN ven_descriptionmaster VDM ON VDM.description_id = vfrm..description_id
inner join ven_machinemaster vm on vm.machine_id = vfrm..machine_id
inner join ven_jobcodemaster vjm on vjm.job_id = vfrm.job_id
inner join Dim_Time dt on dt.Date_Id = vfrm.date_id
where vfrm.entry_date = '20111208'
and vfrm.shift_id =2
and vfrm.description_id in (1,3,5)
and vfrm.job_id not in (9999,9998,9996,9994)
and vjm.job_status ='ACTIVE'
group by description_name, DateString
output:

please help me out to solve this issue..
Regards
T.Navin
updated:
i am saving the above sql query result into an data set in c#.. is it possible to filter the columns which contains '0' in both the rows..so that the dataset looks like required output in the snap shot