SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 
SELECT DISTINCT 
con.RequestDateTime as 'Дата',
Cs.ShortName as 'Наименование участника', 
U.Email as 'Пользователь', 
CASE WHEN Con.servicetype=2 then 'Да' else 'Нет' END as 'Заявка на подключение сервиса Грузы',
CASE WHEN Con.servicetype=3 then 'Да' else 'Нет' END as 'Заявка на подключение сервиса Топливо',CASE WHEN C.ActivityType=2 then 'Да' else 'Нет' END as 'Наличие договора Грузы',
CASE WHEN C.ActivityType=3 then 'Да' else 'Нет' END as 'Наличие договора Заправки',COUNT(DISTINCT B.ID) as 'Количество ТС'
FROM [PortalFortisIdentity].[dbo].[AspNetUsers] U
JOIN [FortisDataStore].[dbo].[Contractors] Cs ON U.ClientId=Cs.MemberId
JOIN [FortisDataStore].[dbo].[Contracts] C ON Cs.Id=C.ContractorId
JOIN [FortisDataStore].[dbo].[Clients] D on Cs.INN=D.Inn
JOIN [FortisDataStore].[dbo].[Trucks] B ON D.Id=B.ClientId
JOIN [FortisDataStore].[dbo].[ConnectToServiceRequests] as Con on  D.Id=con.ClientId WHERE (U.Email NOT LIKE '%fortis%online%' AND U.Email NOT LIKE '%monopoly.su' AND U.Email NOT LIKE '%[А-яЁё]%' AND U.Email LIKE '%@%') 
AND (U.UpdatedBy!='QuickRegistration' AND U.IsQuickRegistration!='1')
AND C.ActivityType in (2,3) 
AND B.IsClosed='0' AND C.IsClosed='0' AND U.IsClosed=0
AND (((C.FactEndDate>GETDATE() OR C.FactEndDate IS NULL) AND C.AutomaticProlongation IN ('0', '1')) OR C.AutomaticProlongation='2')
and Con.RequestDateTime > '2019-09-01 00:00:00.000' and RequestDateTime < '2020-03-13 23:59:00.000' --период поиска
GROUP BY Cs.ShortName, C.ActivityType, C.Id, U.Email, Con.ServiceType, con.RequestDateTime
order by con.RequestDateTime
SET DEADLOCK_PRIORITY LOW

SELECT DISTINCT Cts1.ShortName as 'Наименование участника',
Count(Ed1.Id) as 'Количество оформленных заявок на перевозку за данный месяц'
FROM [FortisDataStore].[dbo].[ElectronicDocuments] AS Ed1
JOIN [FortisDataStore].[dbo].[Contracts] as CT1 on Ed1.ContractId = CT1.Id
JOIN [FortisDataStore].[dbo].[Contractors] as Cts1 on CT1.ContractorId = Cts1.Id
WHERE Ed1.ElectronicDocumentStatus in (8,12,14,15) 
and Ed1.CreatedAt > '2020-02-01 00:00:00.000' and Ed1.CreatedAt < '2020-02-29 23:59:00.000'  
GROUP BY Cts1.ShortName

SELECT DISTINCT Cl.Name as 'Наименование участника', 
COUNT(DISTINCT Tr.ID) as 'Количество заправок за указанный месяц'
FROM [Fuel].[dbo].[Transactions] AS Tr
JOIN [FortisDataStore].[dbo].[Trucks] AS T ON Tr.TruckId=T.Id
JOIN [FortisDataStore].[dbo].[Clients] AS Cl ON Cl.Id=T.ClientId
WHERE Tr.Status = '1' AND      
Tr.RefuelingDate between '2020-02-01 00:00:00.000' and  '2020-02-29 23:59:00.000'                             --период выборки 
GROUP BY Cl.Name

 , ClientId
	               , sum( iif( servicetype=2, 1, 0 ) as 'Грузы'
	               , sum( iif( servicetype=3, 1, 0 ) as 'Топливо' 

 select con.'Месяц' -- ошибка Incorrect syntax near
        , Cs.ShortName as 'Наименование участника'
        , U.Email as 'Пользователь'
		, con.'Грузы' -- ошибка Incorrect syntax near
		, con.'Топливо' --ошибка Incorrect syntax near
		, iif( exists( select * from C where C.ContractorId = Cs.Id and C.ActivityType=2 ), 1, 0) as 'Наличие договора Грузы'
        , iif( exists( select * from C where C.ContractorId = Cs.Id and C.ActivityType=3 ), 1, 0) as 'Наличие договора Заправки'
		, G.'Количество оформленных заявок на перевозку за данный месяц' --ошибка Incorrect syntax near