UFN_REVENUELETTER_CURRENTCOUNT_2

Returns a count of current revenue letters with the passed in revenue, letter, and constituent IDs.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@LETTERCODEID	uniqueidentifier	IN
@ACKNOWLEDGEEID	uniqueidentifier	IN
@OUTOFDATE	bit	IN
@MKTPACKAGEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUELETTER_CURRENTCOUNT_2
            (
                @REVENUEID uniqueidentifier,
                @LETTERCODEID uniqueidentifier,
                @ACKNOWLEDGEEID uniqueidentifier,
                -- Including OUTOFDATE since it seems to be needed to trigger

                -- checking the table constraint

                @OUTOFDATE bit,
        @MKTPACKAGEID uniqueidentifier
            )
            returns int
            as
            begin            
                declare @COUNT int

                select 
          @COUNT = count(*)
                from 
          dbo.REVENUELETTER
                where
                    REVENUEID = @REVENUEID and
                    LETTERCODEID = @LETTERCODEID and
                    (MKTPACKAGEID is null and @MKTPACKAGEID is null or MKTPACKAGEID = @MKTPACKAGEID) and
                    ACKNOWLEDGEEID = @ACKNOWLEDGEEID and
                    OUTOFDATE = 0

                return @COUNT
            end