USP_SIMPLEDATALIST_IMPORTSOURCE

CREATE procedure dbo.USP_SIMPLEDATALIST_IMPORTSOURCE(@CURRENTAPPUSERID uniqueidentifier, @IMPORTSOURCETYPECODE tinyint)
as
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.IMPORTSOURCE
  where ((SITEID is null) or (dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, SITEID) = 1))
  and ((@IMPORTSOURCETYPECODE is null) or (IMPORTSOURCETYPECODE = @IMPORTSOURCETYPECODE))
    order by NAME