UFN_DONORCHALLENGE_GETSPLITS_2

Returns all splits for a given donor challenge (including multicurrency fields).

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DONORCHALLENGEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_DONORCHALLENGE_GETSPLITS_2
(
    @DONORCHALLENGEID uniqueidentifier
)
returns table as return 
    select 
        ID,
        DESIGNATIONID,
        AMOUNT,
        BASECURRENCYID,
        ORGANIZATIONEXCHANGERATEID,
        ORGANIZATIONAMOUNT
    from 
        dbo.DONORCHALLENGESPLIT
    where 
        DONORCHALLENGEID = @DONORCHALLENGEID