USP_REVENUE_SOLICITOR_DATALIST_GETDATA

Returns data used by datalists which display solicitors for a revenue detail record.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_REVENUE_SOLICITOR_DATALIST_GETDATA
            (
                @ID uniqueidentifier
            )
            as 
                set nocount on;

                select
                    REVENUESOLICITOR.ID,
                    CONSTITUENT.NAME,
                    REVENUESOLICITOR.AMOUNT,
                    REVENUESOLICITOR.SEQUENCE,
                    CONSTITUENT.ID
                from 
                    dbo.REVENUESOLICITOR
                    inner join dbo.REVENUESPLIT on REVENUESOLICITOR.REVENUESPLITID = REVENUESPLIT.ID
                    left join dbo.CONSTITUENT on REVENUESOLICITOR.CONSTITUENTID = CONSTITUENT.ID
                where 
                    REVENUESPLIT.REVENUEID = @ID
                order 
                    by REVENUESOLICITOR.SEQUENCE;