[MSSQL]多人群组审批

 

--==================================================
--用途：多人审批
--作者: 龚德辉
--日期：2008-03-15
--==================================================


Create    Procedure [dbo].[ApproveTaskMutiType](
		@ApproveUserID  as int=null
		,@TaskCode    as nvarchar(11)=null
        ,@Result      as nchar(1)=null
        ,@Ref         as nvarchar(50)=null
        ,@Back        as nchar(1)=null
        ,@BackLevel   as int 
)
as
begin
 declare @temp nvarchar(15),
		 @Progress nvarchar(2000),
		 @currEndLeve