CREATE PROCEDURE _SpoolRevision_InsertNewRevision(@SpoolId int = NULL)ASSET NOCOUNT ON DECLARE @NewSpoolRevisionNumber int BEGIN IF @SpoolId = NULL BEGIN RAISERROR ('_SpoolRevision_InsertNewRevision :: SpoolId must be assigned a value and cannot be null', 16, 1) END ELSE BEGIN EXEC @NewSpoolRevisionNumber = _SpoolRevision_GetNextSpoolRevisionNumber @SpoolId IF @NewSpoolRevisionNumber = NULL BEGIN RAISERROR ('_SpoolRevision_InsertNewRevision :: NewSpoolRevisionNumber was returned as null from procedure _SpoolRevision_GetNextSpoolRevisionNumber', 16, 1) END ELSE BEGIN -- Do the Insert All is Good INSERT INTO SpoolRevision (SpoolId, SpoolRevisionNumber) VALUES (@SpoolId, @NewSpoolRevisionNumber) IF @@ERROR <> 0 BEGIN RAISERROR ('_SpoolRevision_InsertNewRevision :: There was an issue while inserting new Work Package Revision', 16, 1) END -- END IF END -- END IF END -- END IF ENDRETURNGO