select system_no AS 'SYSTEM NAME',
       SUM(CASE WHEN (mat_2='AS') THEN mat_2_size END) as 'AS',
       SUM(CASE WHEN (mat_2='SS') THEN mat_2_size END) as 'SS',
       SUM(CASE WHEN (mat_2='CS') THEN mat_2_size END) as 'CS'
from fabrication_table
where welding_date between '2014-02-03' and '2014-02-09'
group by system_no
UNION
select 'TOTAL' as 'SYSTEM NAME',
       SUM(CASE WHEN (mat_2='AS') THEN mat_2_size END) as 'AS',
       SUM(CASE WHEN (mat_2='SS') THEN mat_2_size END) as 'SS',
       SUM(CASE WHEN (mat_2='CS') THEN mat_2_size END) as 'CS'
from fabrication_table
where welding_date between '2014-02-03' and '2014-02-09'

SYSTEM NAME              AS      SS     CS
Auxiliary steam          NULL    NULL   6.75
Chemical dosing          NULL    10.00  NULL
Closed cooling water     NULL    1.50   193.75
Condensate               NULL    NULL   32.00
Demineralized water      NULL    34.00  NULL
Feedwater                NULL    NULL   6.00
Gases (N2, H2, CO2)      NULL    NULL   385.25
GT air intake anti-icing NULL    NULL   220.50
Main steam & by-pass     49.50   NULL   84.00
Seawater intake          NULL    27.50  NULL
ST drains                37.50   NULL   175.50
ST seals steam           NULL    2.25   175.00
TOTAL                    87.00   75.25  1278.75

,SUM(CASE WHEN (mat_2='AS') THEN mat_2_size END) as 'AS'

,SUM(CASE WHEN (mat_2='AS') THEN mat_2_size END) as 'AS'

,SUM(CASE WHEN (mat_2='AS') THEN mat_2_size END) as 'AS'

,SUM(CASE WHEN (mat_2='AS') THEN coalesce(mat_2_size,0) END) as 'AS'

SELECT ISNULL(column,0) FROM...