select SampleID, ProcessName ,sum(case when right(Day_1,2)='01' then Qty else 0 end) day1 ,sum(case when right(Day_1,2)='02' then Qty else 0 end) day2 ,sum(case when right(Day_1,2)='03' then Qty else 0 end) day3 ,sum(case when right(Day_1,2)='04' then Qty else 0 end) day4 ..... ,sum(case when right(Day_1,2)='31' then Qty else 0 end) day31 from TabA group by SampleID, ProcessName
,sum(case when right(Day_1,2)='01' then Qty else 0 end) day1
,sum(case when right(Day_1,2)='02' then Qty else 0 end) day2
,sum(case when right(Day_1,2)='03' then Qty else 0 end) day3
,sum(case when right(Day_1,2)='04' then Qty else 0 end) day4
.....
,sum(case when right(Day_1,2)='31' then Qty else 0 end) day31
from TabA
group by SampleID, ProcessName