UFN_GIFTAIDDISQUALIFIEDATTRIBUTE_IS_UNIQUE

Returns the gift aid qualification status of an event.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@CODETABLEVALUE	uniqueidentifier	IN
@CURRENCYVALUE	money	IN
@CONSTITUENTID	uniqueidentifier	IN
@DATEVALUE	datetime	IN
@FUZZYDATEVALUE	UDT_FUZZYDATE	IN
@MEMOVALUE	nvarchar(255)	IN
@NUMBERVALUE	int	IN
@TEXTVALUE	nvarchar(255)	IN
@HOURMINUTEVALUE	UDT_HOURMINUTE	IN
@BOOLEANVALUE	tinyint	IN
@ATTRIBUTECATEGORYID	uniqueidentifier	IN
@DATATYPE	smallint	IN

Definition

Copy



            CREATE function dbo.UFN_GIFTAIDDISQUALIFIEDATTRIBUTE_IS_UNIQUE
            (
        @CODETABLEVALUE uniqueidentifier = null,
        @CURRENCYVALUE money = 0,
        @CONSTITUENTID uniqueidentifier = null,
        @DATEVALUE datetime = null,
        @FUZZYDATEVALUE dbo.UDT_FUZZYDATE = '00000000',
        @MEMOVALUE nvarchar(255) = '',
        @NUMBERVALUE int = 0,
        @TEXTVALUE nvarchar(255) = '',
        @HOURMINUTEVALUE dbo.UDT_HOURMINUTE = '',
        @BOOLEANVALUE tinyint = 0,
        @ATTRIBUTECATEGORYID uniqueidentifier = null,
        @DATATYPE smallint = 0      
            )

      returns bit
            with execute as caller
            as begin
            declare @COUNT int;

      select @COUNT =COUNT(*) from GIFTAIDDISQUALIFIEDBYATTRIBUTE group by CODETABLEVALUE,CURRENCYVALUE,CONSTITUENTID,DATEVALUE,FUZZYDATEVALUE,MEMOVALUE,NUMBERVALUE,TEXTVALUE,HOURMINUTEVALUE,BOOLEANVALUE,ATTRIBUTECATEGORYID,DATATYPE having COUNT(*) > 1
      if @COUNT > 0 
        return 0;

        return 1;
            end