qds.spDeleteChkShtEvents

Description

Removes all checklist events and linked checklist item events for a given checklist sheet.

Parameters

• @chkShtId (int): ID of the checklist sheet whose events will be deleted.

Key Operations

• Deletes from chkItemEvent where chkShtEventId matches.
• Deletes from chkShtEvent.

Return Value

Total number of deleted rows.

Code Example

-- Example: Delete all records tied to item ID 99
EXEC qds.spDeleteItemId @itemId = 99;