UFN_MEMBERSHIPPROMO_HASVALUE

create function dbo.UFN_MEMBERSHIPPROMO_HASVALUE(@ID uniqueidentifier)
returns bit
with execute as caller
as begin
    if 0 < (select top(1) case PROMOTIONTYPECODE
                              when 0 then case DISCOUNTCALCULATIONTYPECODE
                                                when 0 then AMOUNT
                                                when 1 then [PERCENT]
                                          end
                              when 1 then EXTENSIONVALUE
                          end
            from dbo.MEMBERSHIPPROMO
            where ID = @ID)
    begin
        return 1
    end

    return 0
end