spBulkUpdate_Notification_SiteContent

Parameters

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

Definition

Copy





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

        AS
    BEGIN

        BEGIN TRAN

        set nocount on

        DELETE FROM Notification_SiteContent WHERE NotificationID = @NotificationID

        DECLARE @idoc int

        EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

        INSERT INTO Notification_SiteContent
        (NotificationID,SiteContentID)
        (SELECT @NotificationID, ID  FROM OPENXML (@idoc, '/BulkSiteContentIDs/SiteContentItems/Item',1) WITH (ID int))

        EXEC sp_xml_removedocument @idoc

        COMMIT TRAN

    END