spBulkUpdate_ApproveClassYearNotes

Parameters

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

Definition

Copy



CREATE   PROCEDURE dbo.spBulkUpdate_ApproveClassYearNotes
(
    @ApprovedByID    int,
    @XML as ntext
)

AS

DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

UPDATE ClassYearNotes 
SET 
    IsApproved=A.Approved, 
    ApprovedByID=@ApprovedByID, 
    ApprovedDate=getutcdate(),
    ModifiedDate=getutcdate()
FROM 
    ClassYearNotes INNER JOIN OPENXML (@idoc, '/classnotes/classnote', 1) with (id int, approved bit) A ON ClassYearNotes.ID=A.ID AND IsApproved<>Approved 

EXEC sp_xml_removedocument @idoc