USP_DATALIST_DISCOUNTGLMAPPING

CREATE procedure dbo.USP_DATALIST_DISCOUNTGLMAPPING
as                 
    set nocount on;

    select 
        DISCOUNT.ID, 
        DISCOUNT.[NAME] as DISCOUNTNAME,
        MAP.ACCOUNTNUMBER,
        MAP.PROJECTCODE,
        'IMAGEKEY' = case when (MAP.ACCOUNTNUMBER is null or MAP.ACCOUNTNUMBER = '' 
                        or MAP.PROJECTCODE is null or MAP.PROJECTCODE = '') then 'RES:warning' else '' end
    from dbo.DISCOUNT
    left join dbo.DISCOUNTGLMAPPING as MAP on DISCOUNT.ID = MAP.ID
    where DISCOUNT.SUPERSEDEDBYID is null
    order by DISCOUNT.NAME;