declare @CHKYEAR varchar(4)
declare @BYCHKNAME varchar(12)
select @BYCHKNAME='EM0000000072'
select @CHKYEAR='2003'
select BYCHKNAME,CHKMONTH,PRJNAME,APPRAISE,GETNUM from T_GRADELIST where CHKYEAR=@CHKYEAR and CHKMONTH<>'0' and SPRJNAME 
in(select cno from T_EMPLOYEE where POSITION='院长' or POSITION='副院长')
	AND BYCHKNAME=@BYCHKNAME ORDER BY CHKMONTH,APPRAISE


declare @CHKYEAR varchar(4)
declare @BYCHKNAME varchar(12)
select @BYCHKNAME='EM0000000072'
select @CHKYEAR='2003'
select MAX(BYCHKNAME),MAX(PRJNAME),MAX(APPRAISE),AVG(GETNUM)*0.3 from T_GRADELIST where CHKYEAR=@CHKYEAR and CHKMONTH<>'0' and SPRJNAME 
in(select cno from T_EMPLOYEE where POSITION='院长' or POSITION='副院长')
	GROUP BY BYCHKNAME,APPRAISE ORDER BY BYCHKNAME,APPRAISE


select MAX(BYCHKNAME),MAX(PRJNAME),MAX(APPRAISE),AVG(GETNUM)*0.3 from T_GRADELIST where CHKYEAR=@CHKYEAR and CHKMONTH<>'0' and SPRJNAME 
in(select cno from T_EMPLOYEE where POSITION='所长')
	GROUP BY BYCHKNAME,APPRAISE ORDER BY BYCHKNAME,APPRAISE

select MAX(BYCHKNAME),MAX(PRJNAME),MAX(APPRAISE),AVG(GETNUM)*0.4 from T_GRADELIST where CHKYEAR=@CHKYEAR and CHKMONTH<>'0' and SPRJNAME 
in(select cno from T_EMPLOYEE where position is null or (POSITION<>'院长' and POSITION<>'副院长' and position<>'所长'))
	GROUP BY BYCHKNAME,APPRAISE ORDER BY BYCHKNAME,APPRAISE