UFN_MEMBERSHIPDUESBATCH_CANADDCONSTITUENTTOPROGRAM_2

CREATE function dbo.UFN_MEMBERSHIPDUESBATCH_CANADDCONSTITUENTTOPROGRAM_2
(
    @CONSTITUENTID uniqueidentifier,
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @WHATPAYINGFORVALUE tinyint = 0 --0 = Add, 1 = Renew, 2 = Pay, 3 = Upgrade

)
returns bit with execute as caller
as begin
    declare @MEMBERSHIPID uniqueidentifier = null;

    select top 1 @MEMBERSHIPID = MEMBERSHIP.ID
    from dbo.MEMBER
        inner join dbo.MEMBERSHIP on MEMBER.MEMBERSHIPID = MEMBERSHIP.ID
        inner join dbo.MEMBERSHIPTRANSACTION on MEMBERSHIP.ID = MEMBERSHIPTRANSACTION.ID
    where
        MEMBER.CONSTITUENTID = @CONSTITUENTID and
        MEMBERSHIP.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID and
        MEMBER.ISDROPPED = 0
    order by MEMBERSHIPTRANSACTION.TRANSACTIONDATE desc;

    return dbo.UFN_MEMBERSHIPDUESBATCH_CANADDCONSTITUENTTOPROGRAM_3(@CONSTITUENTID, @MEMBERSHIPPROGRAMID,@WHATPAYINGFORVALUE,@MEMBERSHIPID);
end