Home Forums SQL Server 2008 SQL Server 2008 - General display table in hierarcies RE: display table in hierarcies
peleg
SSCrazy
Points: 2611
More actions
September 11, 2012 at 6:57 am
#1536205
solved
select CASE WHEN MIN(t.r) = 1 then t.name1
ELSE ''
END as name1,
t.name2, t.name3, sum(t.sum1), sum(t.sum2)
from (select *, ROW_NUMBER() over(partition by name1 order by name1) r
from #tbl1) as t
group by t.name1, t.name2, t.name3