check this.
-- I have created test table @test-------
declare @test table(id int,nameplae varchar(2),palecparent int,palceid int,decivecount int)
insert into @test
select 1,'A',0,1,0
union all
select 2,'B',1,2,1
union all
select 3,'C',2,3,1
union all
select 4,'L',2,4,1
union all
select 13,'C',2,3,1
select * from @test
-- hear 2nd temp table is created in which i have populated required detail ------
declare @test2 table(ID varchar(2),palceid int,Totaldecivecount int)
insert into @test2
select distinct nameplae,palceid,'' from @test
update @test2 set Totaldecivecount = (select sum(decivecount) from @test) where palceid = 1
update @test2 set Totaldecivecount = (select sum(decivecount) from @test where palceid IN (3,4)) where palceid = 2
update @test2 set Totaldecivecount = (select sum(decivecount) from @test where palceid = 3) where palceid =3
update @test2 set Totaldecivecount = (select sum(decivecount) from @test where palceid = 4) where palceid = 4
select * from @test2
