use **********
SET STATISTICS TIME ON
declare @p_samAccountName nvarchar(100) = '********';

declare
@Activities table
(
	[ActivityDimKey]            [int] NULL,
	[Activity_id]               [nvarchar](256) NULL,
	[Activity_Title]            [nvarchar](500) NULL,
	[Activity_assignedToUser]   [nvarchar](500) NULL,
    [Activity_StatusValue]      [nvarchar](256) NULL,
	[select_note]               [nvarchar](200) NULL,
	[Activity_Area]             [nvarchar](4000) NULL,
    insertDate                      datetime
)


    /*insert into @Activities
    (
        ActivityDimKey,
        Activity_id,
        Activity_Title,
        Activity_StatusValue,
        [Activity_assignedToUser],
        select_note,
        Activity_Area,
        insertDate
    )*/
	SELECT a.ActivityDimKey,
           a.id                         Activity_id,
           a.title                      Activity_title,
           AStatus.ActivityStatusValue  Activity_StatusValue,
           pers.sAMAccountName          Activity_AssignedToUser_sAMAccountName,
           SUBSTRING(a.id, 1, 2) + ': ' + N'мои и подчиненных'      select_note,
           AreaDS.displayName           Activity_Area,
           getdate()
    FROM [DWDataMart].[dbo].[ActivityDimvw] AS A
	JOIN [DWDataMart].[dbo].[WorkItemDimvw] AS WI ON A.EntityDimKey = WI.EntityDimKey
	JOIN [DWDataMart].[dbo].[WorkItemAssignedToUserFactvw] AS WIAssignedTo ON WIAssignedTo.WorkItemDimKey = WI.WorkItemDimKey AND WIAssignedTo.DeletedDate IS NULL
    inner merge JOIN dbo.get_table_persons(@p_samAccountName) pers on pers.UserDimKey = WIAssignedTo.WorkItemAssignedToUser_UserDimKey
	/*Статус выполнения*/
	LEFT JOIN [DWDataMart].[dbo].[ActivityStatus] AS AStatus ON AStatus.ActivityStatusId = A.Status_ActivityStatusId
	LEFT JOIN [DWDataMart].[dbo].[ActivityAreavw] AS AArea ON AArea.ActivityAreaId = A.Area_ActivityAreaId
	LEFT JOIN DisplayStringDimMV AS AreaDS ON AArea.EnumTypeId = AreaDS.BaseManagedEntityId AND AreaDS.LanguageCode = 'RUS'
	WHERE ISNULL(A.IsDeleted, 0) = 0		-- действие не было удалено
      AND A.ActualStartDate IS NOT NULL		-- действие начали выполнять
      AND A.Status_ActivityStatusId <> 3	-- действие не отменено
      AND isnull(AStatus.ActivityStatusValue, ' ') not in ('Completed', 'Skipped');