This is generated by LLBLGen .UpdateMulti() using Self Servicing

Fast.sql

declare @DateRemovedUTC datetime,@DateRemovedTimeZoneLookupID tinyint,@DateRemovedByID bigint,@IsAssigned bit,@PositionID6 bigint,@PositionID1 bigint,@ExtendedPropertyID2 int,@PositionID3 bigint,@IsExclusion4 bit,@IsCurriculumExcluded5 bit
select @DateRemovedUTC='2011-01-14 22:56:19',@DateRemovedTimeZoneLookupID=43,@DateRemovedByID=1,@IsAssigned=0,@PositionID6=70,@PositionID1=70,@ExtendedPropertyID2=6,@PositionID3=70,@IsExclusion4=0,@IsCurriculumExcluded5=0

UPDATE [Cognition].[dbo].[PositionUsers] SET [DateRemovedUTC]=@DateRemovedUTC,[DateRemovedTimeZoneLookupID]=@DateRemovedTimeZoneLookupID,[DateRemovedByID]=@DateRemovedByID,[IsAssigned]=@IsAssigned FROM ( (SELECT DISTINCT 
[Cognition].[dbo].[Users].[UserID] FROM (((( [Cognition].[dbo].[Users]  INNER JOIN [Cognition].[dbo].[PositionFilterDivision] [LPA_P3]  ON  
[Cognition].[dbo].[Users].[DivisionID] = [LPA_P3].[DivisionID]) INNER JOIN [Cognition].[dbo].[PositionFilter] [LPA_P2]  ON  [LPA_P2].[ID]=[LPA_P3].[ID]) INNER JOIN 
[Cognition].[dbo].[PositionFilter] [LPA_P4]  ON  ( [LPA_P3].[ID] = [LPA_P4].[ID] AND [LPA_P4].[PositionID] = @PositionID1)) INNER JOIN (SELECT [Cognition].[dbo].[UserExtendedPropertyValue].[UserID] FROM (( [Cognition].[dbo].[UserExtendedPropertyValue]  INNER JOIN [Cognition].[dbo].[PositionFilterExtendedPropertyValue]  ON  [Cognition].[dbo].[UserExtendedPropertyValue].[ExtendedPropertyValueID] = [Cognition].[dbo].[PositionFilterExtendedPropertyValue].[ExtendedPropertyValueID]) INNER JOIN [Cognition].[dbo].[PositionFilter]  ON  [Cognition].[dbo].[PositionFilter].[ID]=[Cognition].[dbo].[PositionFilterExtendedPropertyValue].[ID]) WHERE ( ( ( [Cognition].[dbo].[UserExtendedPropertyValue].[ExtendedPropertyID] = @ExtendedPropertyID2 AND [Cognition].[dbo].[PositionFilter].[PositionID] = @PositionID3) AND [Cognition].[dbo].[PositionFilter].[IsExclusion] = @IsExclusion4))) [LPA_E5]  ON  [Cognition].[dbo].[Users].[UserID] = [LPA_E5].[UserID]) WHERE ( [Cognition].[dbo].[Users].[IsCurriculumExcluded] = @IsCurriculumExcluded5)) [LPA_C1]  RIGHT JOIN [Cognition].[dbo].[PositionUsers]  ON  [LPA_C1].[UserID] = [Cognition].[dbo].[PositionUsers].[UserID]) WHERE ( ( ( [Cognition].[dbo].[PositionUsers].[PositionID] = @PositionID6 AND [LPA_C1].[UserID] IS NULL)))

Slow.sql

exec sp_executesql N'UPDATE [Cognition].[dbo].[PositionUsers] SET [DateRemovedUTC]=@DateRemovedUTC,[DateRemovedTimeZoneLookupID]=@DateRemovedTimeZoneLookupID,[DateRemovedByID]=@DateRemovedByID,[IsAssigned]=@IsAssigned FROM ( (SELECT DISTINCT 
[Cognition].[dbo].[Users].[UserID] FROM (((( [Cognition].[dbo].[Users]  INNER JOIN [Cognition].[dbo].[PositionFilterDivision] [LPA_P3]  ON  
[Cognition].[dbo].[Users].[DivisionID] = [LPA_P3].[DivisionID]) INNER JOIN [Cognition].[dbo].[PositionFilter] [LPA_P2]  ON  [LPA_P2].[ID]=[LPA_P3].[ID]) INNER JOIN 
[Cognition].[dbo].[PositionFilter] [LPA_P4]  ON  ( [LPA_P3].[ID] = [LPA_P4].[ID] AND [LPA_P4].[PositionID] = @PositionID1)) INNER JOIN (SELECT [Cognition].[dbo].[UserExtendedPropertyValue].[UserID] FROM (( [Cognition].[dbo].[UserExtendedPropertyValue]  INNER JOIN [Cognition].[dbo].[PositionFilterExtendedPropertyValue]  ON  [Cognition].[dbo].[UserExtendedPropertyValue].[ExtendedPropertyValueID] = [Cognition].[dbo].[PositionFilterExtendedPropertyValue].[ExtendedPropertyValueID]) INNER JOIN [Cognition].[dbo].[PositionFilter]  ON  [Cognition].[dbo].[PositionFilter].[ID]=[Cognition].[dbo].[PositionFilterExtendedPropertyValue].[ID]) WHERE ( ( ( [Cognition].[dbo].[UserExtendedPropertyValue].[ExtendedPropertyID] = @ExtendedPropertyID2 AND [Cognition].[dbo].[PositionFilter].[PositionID] = @PositionID3) AND [Cognition].[dbo].[PositionFilter].[IsExclusion] = @IsExclusion4))) [LPA_E5]  ON  [Cognition].[dbo].[Users].[UserID] = [LPA_E5].[UserID]) WHERE ( [Cognition].[dbo].[Users].[IsCurriculumExcluded] = @IsCurriculumExcluded5)) [LPA_C1]  RIGHT JOIN [Cognition].[dbo].[PositionUsers]  ON  [LPA_C1].[UserID] = [Cognition].[dbo].[PositionUsers].[UserID]) WHERE ( ( ( [Cognition].[dbo].[PositionUsers].[PositionID] = @PositionID6 AND [LPA_C1].[UserID] IS NULL)))',N'@DateRemovedUTC datetime,@DateRemovedTimeZoneLookupID tinyint,@DateRemovedByID bigint,@IsAssigned bit,@PositionID6 bigint,@PositionID1 bigint,@ExtendedPropertyID2 int,@PositionID3 bigint,@IsExclusion4 bit,@IsCurriculumExcluded5 bit',@DateRemovedUTC='2011-01-14 22:56:19',@DateRemovedTimeZoneLookupID=43,@DateRemovedByID=1,@IsAssigned=0,@PositionID6=70,@PositionID1=70,@ExtendedPropertyID2=6,@PositionID3=70,@IsExclusion4=0,@IsCurriculumExcluded5=0