USP_SIMPLEDATALIST_SOLICITCODEWITHSTATUS

create procedure dbo.USP_SIMPLEDATALIST_SOLICITCODEWITHSTATUS(@CURRENTAPPUSERID uniqueidentifier)

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 dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) AS SFU
    ON SFU.SITEID=SITE.ID
    where ((SOLICITCODE.SITEID IS NOT NULL AND SFU.SITEID IS NOT NULL) or dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)=0)
    order by 
        SOLICITCODE.[DESCRIPTION];