USP_STORIESUPDATE_ACTIONCENTER

The save procedure used by the add dataform template "Action Center Bulk Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@ACTIONCENTERDATA	varchar(max)	IN	ActionCenterData
@SITEID	int	IN	Site ID
@SPLITCHARONE	varchar(10)	IN	Split Character
@SPLITCHARTWO	varchar(10)	IN	Split Character

Definition

Copy



CREATE PROCEDURE dbo.USP_STORIESUPDATE_ACTIONCENTER
@ID uniqueidentifier = null output,
    @ACTIONCENTERDATA VARCHAR(MAX) = '',
    @SITEID INT = NULL,
    @SPLITCHARONE VARCHAR(10) = '@@',
    @SPLITCHARTWO VARCHAR(10) = '#'
AS
BEGIN


IF ISNULL(@ACTIONCENTERDATA,'') <> '' 
BEGIN

    DECLARE @ACTIONCENTER_RSSDATA table
    (
        ACTIONCENTERRECORD VARCHAR(500)
    );


    DECLARE @ACTIONCENTER_RSSUPDATE table
    (
        ACTIONITEMID uniqueidentifier,
        STORIESID int
    );


    INSERT INTO @ACTIONCENTER_RSSDATA 
    SELECT element_value AS ACTIONCENTERRECORD
    FROM dbo.UFN_PARSE_STRING(@ACTIONCENTERDATA,@SPLITCHARONE)

    INSERT INTO @ACTIONCENTER_RSSUPDATE
    SELECT SUBSTRING([ACTIONCENTERRECORD], 1, NULLIF(CHARINDEX('#', [ACTIONCENTERRECORD]) - 1, -1)) AS ACTIONITEMID,
        SUBSTRING([ACTIONCENTERRECORD], CHARINDEX('#', [ACTIONCENTERRECORD]) + 1, LEN([ACTIONCENTERRECORD])) AS STORIESID
    FROM @ACTIONCENTER_RSSDATA 


    UPDATE ACTIONCENTER 
        SET STORYID = A.STORIESID 
    FROM @ACTIONCENTER_RSSUPDATE A
    JOIN ACTIONCENTER B
        ON A.ACTIONITEMID = B.ACTIONITEMID 
    AND SITECONTENTID = @SITEID
  END

END