Константин Цветков

Мне нужно разделить заказ по вендорам.

SELECT Sungero_Core_Recipient.Name AS Addressee,
	     dev_Kemero1_CityDistricts.Name AS District,
	     1 AS [Count]
  FROM [Sungero_Content_EDoc]
    JOIN dev_Kemero1_CityDistricts ON dev_Kemero1_CityDistricts.Id  = [Sungero_Content_EDoc].Districtdev_Kemerov_dev
    JOIN Sungero_Core_Recipient ON Sungero_Core_Recipient.Id = [Sungero_Content_EDoc].InAddressee_Docflow_Sungero
  WHERE [Sungero_Content_EDoc].Name LIKE 'Обращение%'

SELECT Sungero_Core_Recipient.Name AS Addressee,
	     dev_Kemero1_CityDistricts.Name AS District,
	     COUNT(*) AS [Count]
  FROM [Sungero_Content_EDoc]
    JOIN dev_Kemero1_CityDistricts ON dev_Kemero1_CityDistricts.Id  = [Sungero_Content_EDoc].Districtdev_Kemerov_dev
    JOIN Sungero_Core_Recipient ON Sungero_Core_Recipient.Id = [Sungero_Content_EDoc].InAddressee_Docflow_Sungero
  WHERE [Sungero_Content_EDoc].Name LIKE 'Обращение%'
  GROUP BY Sungero_Core_Recipient.Name, dev_Kemero1_CityDistricts.Name

SELECT dc.session_id          AS [SPID],
       dc.client_net_address  AS [IP клиента],
       sp.hostname            AS [Имя PC клиента],
       dc.local_net_address   AS [IP подключения к серверу],
       dc.net_transport       AS [Протокол подключения],
       dc.local_tcp_port      AS [Порт],
       sp.[program_name]      AS [Имя программы],
       sp.loginame
  FROM sys.dm_exec_connections dc
    INNER JOIN MASTER.sys.sysprocesses sp ON dc.session_id = sp.spid