Files
2015-04-16 21:51:14 +02:00

28 lines
790 B
SQL

DROP procedure IF EXISTS `TerminatePositionAssignment`
#
CREATE PROCEDURE `TerminatePositionAssignment`(
IN positionAssignmentId INT,
IN terminatedDateTimeUtc DATETIME,
IN terminatedByPersonId INT,
IN terminatedByPositionId INT,
IN terminationNotes TEXT
)
BEGIN
UPDATE PositionAssignments
SET
PositionAssignments.Active=0,
PositionAssignments.TerminatedDateTimeUtc=terminatedDateTimeUtc,
PositionAssignments.TerminatedByPersonId=terminatedByPersonId,
PositionAssignments.TerminatedByPositionId=terminatedByPositionId,
PositionAssignments.TerminationNotes=terminationNotes
WHERE
PositionAssignments.PositionAssignmentId=positionAssignmentId AND
PositionAssignments.Active=1;
SELECT ROW_COUNT() AS RowsUpdated;
END