Database

SELECT  dbo.ContactMaster.BmcCustKey
       ,Sum(CASE    WHEN    dbo.LocationAccessGrant.CanAccessLocation = 1
                    THEN    1
                    ELSE    0
            END) accesscount
FROM    dbo.ContactMaster
LEFT OUTER JOIN dbo.LocationAccessGrant
    ON  dbo.ContactMaster.CompanyID = dbo.LocationAccessGrant.CompanyID
    AND dbo.ContactMaster.ContactIdentity = dbo.LocationAccessGrant.ContactIdentity
GROUP BY dbo.ContactMaster.BmcCustKey
        ,dbo.LocationAccessGrant.CanAccessLocation
ORDER BY dbo.ContactMaster.BmcCustKey

SELECT     *
FROM         Employees
WHERE     (FirstName LIKE N'%ф%')

DECLARE @id int = 0
SET @id = (SELECT id FROM INSERTED  )

select a.id
      ,a.upload_date
      ,a.office_id
  from (  select max(m.upload_date) max_upload_date
                ,m.office_id office_id
            from master m
           group by m.office_id
       ) tmp
      ,master a
 where a.upload_date = tmp.max_upload_date
   and a.office_id = tmp.office_id
;

DECLARE @StringToSearch NVARCHAR(MAX)
SET @StringToSearch = 'ENTER_SP_TO_SEARCH'

SELECT    
    [name],   
    (   
        SELECT    
            OBJECT_DEFINITION(obj2.object_id) AS [text()]   
        from sys.all_objects obj2   
        where obj2.object_id = obj1.object_id   
        FOR XML PATH(''), TYPE   
    ) AS Obj_text,   
    [type] as ObjType    
FROM sys.all_objects obj1  
WHERE OBJECT_DEFINITION(object_id([name])) LIKE '%' + @StringToSearch + '%'