UFN_CONSTITUENCY_ISUNIQUE

Validates whether the constituency is unique.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@CONSTITUENCYCODEID	uniqueidentifier	IN
@DATEFROM	date	IN
@DATETO	date	IN

Definition

Copy



        CREATE function dbo.UFN_CONSTITUENCY_ISUNIQUE
        (
            @CONSTITUENTID uniqueidentifier,
            @CONSTITUENCYCODEID uniqueidentifier,
            @DATEFROM date,
            @DATETO date
        )
        returns bit
        with execute as caller
        as begin
            declare @DUPLICATECOUNT int;

            select
                @DUPLICATECOUNT = count(*)
            from
                dbo.CONSTITUENCY
            where
                CONSTITUENTID = @CONSTITUENTID and
                CONSTITUENCYCODEID = @CONSTITUENCYCODEID and
                (
                    ( DATETO   between @DATEFROM and @DATETO) or
                    (@DATETO   between  DATEFROM and  DATETO) or
                    ( DATEFROM between @DATEFROM and @DATETO) or
                    (@DATEFROM between  DATEFROM and  DATETO) or

                    ( DATEFROM is null and @DATEFROM <=  DATETO)   or
                    (@DATEFROM is null and  DATEFROM <= @DATETO)   or
                    ( DATETO   is null and @DATETO   >=  DATEFROM) or
                    (@DATETO   is null and  DATETO   >= @DATEFROM) or

                    (@DATEFROM is null and  DATEFROM is null) or
                    (@DATETO   is null and  DATETO   is null) or
                    (@DATEFROM is null and @DATETO   is null) or
                    ( DATEFROM is null and  DATETO   is null)
                );

            if (@DUPLICATECOUNT <= 1)
                return 1;

            return 0;
        end