USP_DATALIST_REGISTRANT_DONATION

CREATE procedure dbo.USP_DATALIST_REGISTRANT_DONATION
(
        @REGISTRANTID uniqueidentifier = null
)with execute as caller
as
    set nocount on;

    select 
        REGISTRANTDONATION.[ID],
        REGISTRANTDONATION.[REGISTRANTID],
        REGISTRANTDONATION.[VOLUNTARYDONATION]
    from 
        dbo.REGISTRANTDONATION
    where
        REGISTRANTID = ISNULL(@REGISTRANTID,REGISTRANTID)