UFN_REVENUE_GETSKIPPEDTRANSACTIONCOUNT

Returns the number of consecutive skipped transaction between the as of date and the next transaction date.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            CREATE function [dbo].[UFN_REVENUE_GETSKIPPEDTRANSACTIONCOUNT] (
                    @REVENUEID uniqueidentifier, 
                    @ASOFDATE datetime) 
                returns int

            begin
                declare @RETVAL int

                select @RETVAL = count(*) 
                from dbo.RECURRINGGIFTACTIVITY 
                where SOURCEREVENUEID = @REVENUEID and TYPECODE = 1
                        and SCHEDULEDATE <= @ASOFDATE
                        and SCHEDULEDATE > 
                            (select Max(RGASUB.SCHEDULEDATE) from dbo.RECURRINGGIFTACTIVITY RGASUB
                                where RGASUB.SOURCEREVENUEID = @REVENUEID and (RGASUB.TYPECODE = 0)
                                        and RGASUB.SCHEDULEDATE <= @ASOFDATE
                            );

                return coalesce(@RETVAL, 0)

            end