USP_DATALIST_COMBINATION

CREATE procedure dbo.USP_DATALIST_COMBINATION
    (
    @INCLUDEINACTIVE bit = 1
    )
as
    set nocount on;

    select COMBINATION.ID,
            COMBINATION.NAME,
            COMBINATION.DESCRIPTION,
            COMBINATION.ISACTIVE,
            dbo.UFN_COMBINATION_HASONLINEAVAILABILITY(COMBINATION.ID) as APPROVEDFORWEB,
            COMBINATION_MICROSITEEMAILTEMPLATE.ID as MICROSITEEMAILTEMPLATEID,
            coalesce(COMBINATION_MICROSITEEMAILTEMPLATE.ACTIVE, 0) as CUSTOMACKNOWLEDGEMENTENABLED
    from dbo.COMBINATION
    left outer join dbo.COMBINATION_MICROSITEEMAILTEMPLATE
        on COMBINATION.ID = COMBINATION_MICROSITEEMAILTEMPLATE.COMBINATIONID
    where
        @INCLUDEINACTIVE = 1
        or ISACTIVE = 1
    order by NAME;