• As everyone else has said formatting is best left to reporting tools but this will do what you want.

    declare @delim1 varchar(30),@delim2 varchar(30),@delim3 varchar(30)

    select @delim1 = '---------------'+ char(10) + char(13)

    select @delim2 = char(10) + char(13)

    select @delim3 = ','

    select @delim1,facility,@delim2,sum(case when something = somethingelse then 1 else 0 end) as con1,@delim3,sum(case when something = somethingelse then 1 else 0 end) as con2,@delim3,sum(case when something = somethingelse then 1 else 0 end) as con3,@delim2,@delim1 from #temp

    group by facility