UFN_COMBINATION_HASONLINEAVAILABILITY

create function dbo.UFN_COMBINATION_HASONLINEAVAILABILITY(@ID uniqueidentifier)
returns bit
as begin
    if exists (
        select 1
        from dbo.COMBINATIONAVAILABILITY
        inner join dbo.COMBINATIONAVAILABILITYSALESMETHOD on COMBINATIONAVAILABILITYSALESMETHOD.COMBINATIONAVAILABILITYID = COMBINATIONAVAILABILITY.ID
        inner join dbo.SALESMETHOD on SALESMETHOD.ID = COMBINATIONAVAILABILITYSALESMETHOD.SALESMETHODID
        where COMBINATIONAVAILABILITY.COMBINATIONID = @ID and SALESMETHOD.TYPECODE = 2  -- Online Sales

    ) begin
        return 1;
    end

    return 0;
end