UFN_MEMBERSHIPPROGRAM_GETALLOWMULTIPLEMEMBERSHIPS

create function dbo.UFN_MEMBERSHIPPROGRAM_GETALLOWMULTIPLEMEMBERSHIPS
(
    @MEMBERSHIPPROGRAMID uniqueidentifier
)
returns bit
with execute as caller
as begin
    declare @ALLOWMULTIPLEMEMBERSHIPS as bit

    select @ALLOWMULTIPLEMEMBERSHIPS = ALLOWMULTIPLEMEMBERSHIPS
    from dbo.MEMBERSHIPPROGRAM
    where ID = @MEMBERSHIPPROGRAMID

    return @ALLOWMULTIPLEMEMBERSHIPS
end