USP_SIMPLEDATALIST_TRANSLATIONTABLE

CREATE procedure dbo.USP_SIMPLEDATALIST_TRANSLATIONTABLE 
(
    @COURSEGRADINGMARKINGCOLUMNID uniqueidentifier = null,
    @VALUESALLOWED tinyint = null
)
as
    select 
        TRANSLATIONTABLE.ID as VALUE, 
        TRANSLATIONTABLE.NAME as LABEL
    from dbo.TRANSLATIONTABLE
    left join dbo.UFN_COURSEGRADINGMARKINGCOLUMN_INVALIDTRANSLATIONTABLES(@COURSEGRADINGMARKINGCOLUMNID, @VALUESALLOWED) TT
        on TT.ID = TRANSLATIONTABLE.ID
    where (@COURSEGRADINGMARKINGCOLUMNID is null or @VALUESALLOWED is null) or (TT.ID is null)
    order by TRANSLATIONTABLE.NAME