USP_DATALIST_DONORCHALLENGE_SPLIT

This datalist returns a list of splits for a donor challenge.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



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

                select
                    ID,
                    dbo.UFN_DESIGNATION_BUILDNAME([DESIGNATIONID]) as 'Designation',
                    AMOUNT,
          BASECURRENCYID
                from dbo.DONORCHALLENGESPLIT
                where DONORCHALLENGEID = @ID
                order by Designation;