USP_SIMPLEDATALIST_GETACTIONCENTER

   create procedure dbo.USP_SIMPLEDATALIST_GETACTIONCENTER
    as
     Select distinct SC.ID As Value, SC.Title As Label from dbo.ADVOCACYACTIVITY (nolock) AA
          Inner Join dbo.SiteContent (nolock) SC
          On AA.SITECONTENTID = SC.ID
        Order by SC.Title