UFN_REVENUEDETAIL_GETMAXSOLICITORSPLITAMOUNTS

Returns a collection of a revenue's splits and the maximum solicitor amount for that split.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUEDETAIL_GETMAXSOLICITORSPLITAMOUNTS
            (
                @REVENUEID uniqueidentifier
            )
            returns table            
            AS            
            return 
                (
                    select 
                        REVENUESPLIT.ID,
                        REVENUESPLIT.DESIGNATIONID,
                        max(REVENUESOLICITOR.AMOUNT) as MAXAMOUNT
                    from dbo.REVENUESPLIT
                    inner join dbo.REVENUESOLICITOR on REVENUESPLIT.ID = REVENUESOLICITOR.REVENUESPLITID
                    where 
                        REVENUEID = @REVENUEID
                    group by REVENUESPLIT.ID, REVENUESPLIT.DESIGNATIONID
                );