UFN_DISCOUNTGROUPSIZE_VALIDPERCENTCHECK

Checks to insure the percent column is valid on group size discounts

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@AMOUNT	money	IN
@PERCENT	decimal(5, 2)	IN
@DATECHANGED	datetime	IN

Definition

Copy



            create function dbo.UFN_DISCOUNTGROUPSIZE_VALIDPERCENTCHECK
            (
                @ID uniqueidentifier,
                @AMOUNT money,
                @PERCENT decimal(5,2),
                @DATECHANGED datetime
            )
            returns bit
            with execute as caller
            as begin

                declare @CALCULATIONTYPECODE int = 
                    (
                        select
                            [CALCULATIONTYPECODE]
                        from dbo.[DISCOUNT]
                        inner join dbo.[GROUPSIZEDISCOUNT]
                            on [DISCOUNT].[ID] = [GROUPSIZEDISCOUNT].[DISCOUNTID]
                        where [GROUPSIZEDISCOUNT].[ID] = @ID
                    )

                if @CALCULATIONTYPECODE = 1 and (@PERCENT > 100 or @PERCENT <= 0)
                begin
                    return 0;
                end

                return 1;  --good to go


            end