DenSyo
Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору kapiton1 не знаю на сколько вас правильно понял... select doroga as [Регион],IVC_dorogi as [Управление],rzd_site.domain as [Имя домена],mac.chk as [MAC:0] from (SELECT SYS.Resource_Domain_OR_Workgr0 AS domain, COUNT(DISTINCT SYS.ResourceID) AS chk, IIF(MAC.MAC_Addresses0 LIKE '%0', MAC.MAC_Addresses0, Null) AS Mac0, IIF(MAC.MAC_Addresses0 LIKE '%1', MAC.MAC_Addresses0, Null) AS Mac1, IIF(MAC.MAC_Addresses0 LIKE '%2', MAC.MAC_Addresses0, Null) AS Mac2 FROM v_R_System AS SYS LEFT OUTER JOIN v_RA_System_MACAddresses AS MAC ON SYS.ResourceID = MAC.ResourceID WHERE (SYS.Client0 = 1) AND (SYS.Resource_Domain_OR_Workgr0 IN ('GVC', 'MAIN', 'SVRW', 'ZRW', 'KBSH', 'ORW', 'KLGD', 'SKZD', 'GRW', 'KRW', 'WSR', 'SURW', 'NRR', 'ESRR', 'MSK', 'PVRR', 'SERWRZD', 'DVGD')) GROUP BY SYS.Resource_Domain_OR_Workgr0 ) as mac left join dbo.v_tmp_RZD_info rzd_site ON rzd_site.domain=mac.domain ORDER BY doroga |