SELECT  ef.eMapName,
		iss.cmb_Shop,
		em.eLocaleID,
		(SELECT [eUserName]
		  FROM xxx
		  WHERE eAttribute = 'Department' AND eValue = eg.cmb_Dep		  
                              INTERSECT
		  SELECT [eUserName]
		  FROM xxx
		  WHERE eAttribute = 'Shop'   AND eValue = eg.cmb_Shop
		  INTERSECT
		  SELECT [eUserName]
		  FROM xxx
		  WHERE eAttribute = 'Subdepartment' AND eValue = eg.cmb_Subdep) as users,
		  ef.EFOLDERID
--COUNT(*) TOTAL,

--SUM(case when ef.eArchived = 1 then 1 else 0 end)                                  end,
--SUM(case when iss.DT_Termin > Sysdatetime() then 1 else 0 end)              over,
--SUM(case when iss.int_Status = 1 then 1 else 0 end)                                 issued,
--SUM(case when iss.int_Status > 1 and iss.int_Status < 5 then 1 else 0 end) work,
--SUM(case when es.eStagename = 'GS_Escalation' then 1 else 0 end)         escal


FROM [Metastorm].[dbo].eFolder    AS ef INNER JOIN
     [Metastorm].[dbo].eMap       AS em ON ef.eMapName  = em.eMapName 
	               INNER JOIN
     [Metastorm].[dbo].eStage     AS es ON  ef.eMapName = es.eMapName 
		em.eMapName = es.eMapName 
		INNER JOIN
     [Metastorm].[dbo].Issues AS iss
		ON ef.eFolderID = eg.eFolderID 
		WHERE em.eLocaleID      = 'Default'
AND ef.eStageName     IS NOT NULL
AND es.eLocaleID      = 'Default'
AND is.cmb_Shop = 'YYYYYY'
--GROUP BY
--ef.eMapName,
--iss.cmb_Shop,
--em.eLocaleID
--ea.eUserName

SELECT * FROM
(SELECT  ef.eMapName,
		eg.cmb_Shop,
		em.eLocaleID,
		(SELECT [eUserName]
                             INTERSECT...
                             SELECT [eUserName]...) as users
)
GROUP BY ...users

select tab_name, col_name
from (
select name as tab_name, (select top 1 name from syscolumns b where a.id = b.id) as col_name 
from sysobjects a) x
group by tab_name, col_name