Anonymous

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'  ENDGO