CREATE NONCLUSTERED INDEX [IX_HashCode] ON [dbo].[Resources] 
(
	[HashCode] ASC
)
INCLUDE ( [Id])
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 85) ON [PRIMARY]

CREATE PROCEDURE [dbo].[UpdateResourceSupplierType]
	@NewSupplierTypeId TINYINT,
	@HashCode int
AS
BEGIN
	SET NOCOUNT ON	
	
	MERGE INTO dbo.ResourceExtParams
	USING  (select Id from dbo.Resources
			where HashCode = @HashCode) r
			on (r.Id = ResourceId)
	when matched then
		UPDATE  SET SupplierTypeId = @NewSupplierTypeId			
	when not matched by target then
		insert (ResourceId, SupplierTypeId) 
		values (r.Id, @NewSupplierTypeId);	
END

CREATE PROCEDURE [dbo].[UpdateResourceSupplierType]
	@NewSupplierTypeId TINYINT,
	@HashCode int
AS
BEGIN
	SET NOCOUNT ON	
	
	MERGE INTO dbo.ResourceExtParams
	USING  (select Id from dbo.Resources WITH (INDEX(IX_HashCode))
			where HashCode = @HashCode) r
			on (r.Id = ResourceId)
	when matched then
		UPDATE  SET SupplierTypeId = @NewSupplierTypeId			
	when not matched by target then
		insert (ResourceId, SupplierTypeId) 
		values (r.Id, @NewSupplierTypeId);	
END

	declare @NewSupplierTypeId int = 6,
			@HashCode int = -1157169989
	MERGE INTO dbo.ResourceExtParams
	USING  (select Id from dbo.Resources WITH (INDEX(IX_HashCode))
			where HashCode = @HashCode) r
			on (r.Id = ResourceId)
	when matched then
		UPDATE  SET SupplierTypeId = @NewSupplierTypeId			
	when not matched by target then
		insert (ResourceId, SupplierTypeId) 
		values (r.Id, @NewSupplierTypeId);

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) 
	Aug 19 2014 12:21:34 
	Copyright (c) Microsoft Corporation
	Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 10586: )

 ALTER FUNCTION [dbo].[get_tmp]
(
    @p_date_from    datetime,
    @p_date_to      datetime,
    @p_load_tasks   int, -- загружать ли подчиненные задачи
    @p_pocopy       int,
    -- where type
    -- 0 - по дате закрытия
    -- 1 - по дате создания
    -- 2 - по дате закрытия или дате SLA для просроченных за исключением отмененных
    @p_where_type   int,
    @p_folder       nvarchar(100) = N'М'
)

RETURNS TABLE AS RETURN
(

with ids as
(
    select INCIDENT_ID id
      from incidentsm1 obr
     where obr.CLOSE_TIME between cast(@p_date_from AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC' as datetime)
                              and cast(@p_date_to   AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC' as datetime)
           and @p_where_type in (0, 2)
           and not (isnull(obr.HPC_CANCELLED_BY_USER, '') = 't' and @p_where_type in (2))
           and (isnull(obr.folder, N'М') = @p_folder or isnull(@p_folder, '') = '' and isnull(obr.folder, N'М') <> N'H')
    union
    select INCIDENT_ID id
      from incidentsm1 obr
     where obr.open_TIME between cast(@p_date_from AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC' as datetime)
                             and cast(@p_date_to   AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC' as datetime)
           and @p_where_type = 1
           and (isnull(obr.folder, N'М') = @p_folder or isnull(@p_folder, '') = '' and isnull(obr.folder, N'М') <> N'H')
    union
    select INCIDENT_ID id
      from incidentsm1 obr
     where obr.HPC_NEXT_BREACH  between cast(@p_date_from AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC' as datetime)
                                    and cast(@p_date_to   AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC' as datetime)
            and @p_where_type in (2)
            and obr.sla_breach = 't'
            and (obr.CLOSE_TIME is null or obr.CLOSE_TIME between @p_date_from and @p_date_to)
           and (isnull(obr.folder, N'М') = @p_folder or isnull(@p_folder, '') = '' and isnull(obr.folder, N'М') <> N'H')
)
и далее это в подрапросах джойнится с кучей других таблиц, в т.ч. с incidentsm1

    select *
      into #data
      from get_tmp(dateadd(second, -1, @p_open_time_ukr),
                   dateadd(second, +1, @p_open_time_ukr),
                   1,   -- @p_load_tasks
                   0,   -- @p_pocopy = 
                   1,   -- @p_where_type
                   @p_folder
                )

    select *
      into #data
      from get_tmp(dateadd(second, -1, @p_open_time_ukr),
                   dateadd(second, +1, @p_open_time_ukr),
                   1,   -- @p_load_tasks
                   0,   -- @p_pocopy = 
                   1,   -- @p_where_type
                   @p_folder
                )
    where request_id = @p_request_id;;