USP_SIMPLEDATALIST_ACTIONCENTER
return ID and name for advocacy action centers
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_ACTIONCENTER as
select
SC.GUID as VALUE,
SC.TITLE as LABEL
from dbo.SITECONTENT SC
WHERE SC.CONTENTTYPESID = 123
order by SC.TITLE