USP_DATALIST_ACTION_CENTER

CREATE procedure dbo.USP_DATALIST_ACTION_CENTER (@SITECONTENTID int = NULL) with execute as caller
as
    set nocount on;

    select 
        ACTIONCENTER.[ID],
        ACTIONCENTER.[ACTIONITEMID],
        ACTIONCENTER.[SITECONTENTID],
        ACTIONCENTER.[PRIORITYCODE],
        ACTIONCENTER.[PRIORITY],
        ACTIONCENTER.[SORTORDER],
        ACTIONCENTER.[DISPLAYAINAMELIST],
        ACTIONCENTER.[DISPLAYSYNOPSIS],
        ACTIONCENTER.[DISPLAYTHUMBNAIL],
        ACTIONCENTER.[DISPLAYAINAME],
        ACTIONCENTER.[DISPLAYFULLDESCRIPTION],
        ACTIONCENTER.[DISPLAYLOGO],
        AI.NAME,
        AI.TYPE,
        AI.STATUS,
        AI.SYNOPSIS,
        ISNULL(AI.STARTDATE,'1/1/2001') AS STARTDATE,
        ISNULL( AI.ENDDATE, '1/1/2099') AS ENDDATE,
        AM.SENDCOPYTONPO,
    ACTIONCENTER.STORYID
    from 
        dbo.ACTIONCENTER
    INNER JOIN dbo.ACTION_ITEM AI
    ON ACTIONCENTER.ACTIONITEMID = AI.ID
    INNER JOIN dbo.ACTIONITEMMESSAGETEXT AM
    ON ACTIONCENTER.ACTIONITEMID = AM.ACTIONITEMID 
    where ACTIONCENTER.SITECONTENTID = ISNULL(@SITECONTENTID,ACTIONCENTER.SITECONTENTID)
    ORDER BY ACTIONCENTER.SORTORDER ASC