USP_SIMPLEDATALIST_DESIGNATION

CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATION 
(
   @CURRENTAPPUSERID uniqueidentifier,
   @EVENTID uniqueidentifier
)
as

  select ID as VALUE, NAME as LABEL 
  from dbo.UFN_DESIGNATION_GET_BYNOEVENTASSOCIATION(@CURRENTAPPUSERID, @EVENTID)
  order by LABEL