---

SELECT 
---partner,
[napravleniedeyatelnosti], 
sum(budg),
count(count) from 

--dataset
(SELECT 
      p.naimenovanie partner
      ,n.naimenovanie napravleniedeyatelnosti
       --,pi.naimenovanie [pillar]
      ,m.[UID] as count
	 ,[byudzhet] budg
  FROM [mark2].[dbo].[dokument_meropriyatie] m
  join spravochnik_Partneri p on p.UID=[partner]
  join spravochnik_napravleniyadeyatelnosti n on n.uid=[napravleniedeyatelnosti]
  join spravochnik_pillar pi on pi.uid=[pillar]
  where p.naimenovanie='00-00000001'
  --group by p.naimenovanie,
  ----pi.naimenovanie,
  --n.naimenovanie
  ) a

  group by a.[napravleniedeyatelnosti]
--- ,partner