USP_SIMPLEDATALIST_SOLICITCODEWITHSITENOCONSENT

create procedure dbo.USP_SIMPLEDATALIST_SOLICITCODEWITHSITENOCONSENT(
    @CURRENTAPPUSERID uniqueidentifier,
    @FEATUREID uniqueidentifier = null,
    @FEATURETYPE tinyint = null
)
as

    set nocount on;

    select 
        SOLICITCODE.[ID] as VALUE, 
        case when SOLICITCODE.SITEID is null then SOLICITCODE.[DESCRIPTION] else SOLICITCODE.[DESCRIPTION] + ' - ' + SITE.NAME end as LABEL 
    from 
        dbo.SOLICITCODE
        left join dbo.SITE on SOLICITCODE.SITEID = SITE.ID
        left join UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID, @FEATUREID, @FEATURETYPE) USERSITES on USERSITES.SITEID = SITE.ID
    where   SOLICITCODE.ACTIVE = 1 
    and     (SOLICITCODE.SITEID is null or USERSITES.SITEID is not null)
    and     SOLICITCODE.CONSENTCODE = 0
    order by 
        SOLICITCODE.[DESCRIPTION];