[MSSQL]单级审批

--==================================================
--用途：单级审批
--作者: 龚德辉
--日期：2008-03-15
--==================================================
Create Procedure [dbo].[ApproveTask](
	     @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
    declare  @NameVerify varchar(2000),@Name varchar(20)
begin
    if(@Result='Y