insert into test1
select 1000013 as nCustNum , -80.05 as Amt,(364408) as Subv_Chan_Type
union all
select 1000013 as nCustNum , -20.47 as Amt,(364418) as Subv_Chan_Type
union all
select 1000013 as nCustNum , -5.89 as Amt,(364428)as Subv_Chan_Type
union all
select 1000055 as nCustNum , -105.31 as Amt,(364408)as Subv_Chan_Type
union all
select 1000055 as nCustNum , -19.335 as Amt,(364418)as Subv_Chan_Type
union all
select 1000055 as nCustNum , -6.555555as Amt,(364428)as Subv_Chan_Type
union all
select 1000070 as nCustNum ,0 as Amt,(364408)as Subv_Chan_Type
union all
select 1000070 as nCustNum ,0 as Amt,(364418)as Subv_Chan_Type
union all
select 1000070 as nCustNum ,0 as Amt,(364428)as Subv_Chan_Type
union all
select 1000071 as nCustNum , -96.0189740000001 as Amt,(364408)as Subv_Chan_Type
/*
select * from test1
*/
select
nCustNum
,isnull([364408],0) as [364408]
,isnull([364418],0) as [364418]
,isnull([364428],0) as [364428]
from (
select * from test1) p pivot( sum(Amt) for Subv_Chan_Type