CREATE PROCEDURE GetAvailableDrawingRevisionNumbers ( @DrawingId int )
AS
  DECLARE @NextRevision int
  BEGIN
      EXEC @NextRevision = _DrawingRevision_GetNextDrawingRevisionNumber @DrawingId

			SELECT DR.DrawingRevisionNumber AS 'DrawingRevisionNumber'
			FROM	 DrawingRevision DR
			WHERE	 DR.DrawingId = @DrawingId
      UNION
      SELECT @NextRevision AS 'DrawingRevisionNumber'
  END
GO