Master Data Services Custom Business Rule

Fandt selv løsningen :-)

USE [MDS]
GO
/****** Object:  UserDefinedFunction [usr].[f_TeamValidate_Period]    Script Date: 01-02-2019 08:43:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [usr].[f_TeamValidate_Period]
(
    -- Add the parameters for the function here
    @value nvarchar(250)
)
RETURNS BIT
AS
BEGIN

declare @Code as nvarchar(250)
declare @TEAM_ID as decimal(38,0)
declare @Start_Date as datetime2(3)
declare @END_DATE as datetime2(3)
declare @Test_Result as int
declare @Test_Result_C as int

declare @Test_TEAM_ID as decimal(38,0)
declare @Test_Start_Date as datetime2(3)
declare @Test_END_DATE as datetime2(3)

Set @Test_TEAM_ID=0;
set @Test_Result_C=0;

SELECT @Test_TEAM_ID=[TEAM_ID], @Test_Start_Date=[Start_Date], @Test_END_DATE=[END_DATE]
FROM [MDS].[mdm].[viw_SYSTEM_1_3_CHILDATTRIBUTES]
WHERE [Code]=@value


if @Test_TEAM_ID>0
begin

    declare cur CURSOR LOCAL FAST_FORWARD
    for SELECT [Code]
          ,[TEAM_ID]
          ,[Start_Date]
          ,[END_DATE]
        FROM [MDS].[mdm].[viw_SYSTEM_1_3_CHILDATTRIBUTES]
        WHERE [TEAM_ID]=@Test_TEAM_ID and [Code] <> @value
    open cur

    fetch next from cur
    into @Code,@TEAM_ID,@Start_Date,@END_DATE

    while @@FETCH_STATUS = 0
    BEGIN
        SET @Test_Result=0;

        SELECT    @Test_Result=COUNT(*)
        FROM    [MDS].[mdm].[viw_SYSTEM_1_3_CHILDATTRIBUTES]
        WHERE    [TEAM_ID]=@Test_TEAM_ID and
                [Code] <> @value AND
                (
                    @Test_Start_Date BETWEEN [Start_Date] AND [END_DATE]
                    OR
                    @Test_END_DATE BETWEEN [Start_Date] AND [END_DATE]
                )

        if @Test_Result>0
        begin
            set @Test_Result_C = @Test_Result_C +1;
        end

        fetch next from cur
        into @Code,@TEAM_ID,@Start_Date,@END_DATE
    END
    close cur
    deallocate cur

end

if @Test_Result_C>0
begin
    set @Test_Result = 1;
end

RETURN @Test_Result

END