spBulkUpdate_Notification_Workflow

Parameters

Parameter	Parameter Type	Mode	Description
@NotificationID	int	IN
@XML	ntext	IN

Definition

Copy



CREATE     PROCEDURE [dbo].[spBulkUpdate_Notification_Workflow]
        (
        @NotificationID int,
        @XML ntext
        )

        AS
    BEGIN

        BEGIN TRAN

        set nocount on

        DELETE FROM dbo.Notification_Workflow WHERE NotificationID = @NotificationID

        DECLARE @idoc int

        EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

        INSERT INTO dbo.Notification_Workflow
        (NotificationID,WorkflowID)
        (SELECT @NotificationID, ID  FROM OPENXML (@idoc, '/BulkWorkflowIDs/IDItems/IDItem',1) WITH (ID int))

        EXEC sp_xml_removedocument @idoc

        COMMIT TRAN

    END