create proc distincts2 (@a varchar(20),@b varchar(20),@c varchar(20),@d varchar(20),@e varchar(20))
as
begin
select autoid,empno into #aa from(
select 1 as autoid,@a as empno
union all
select 2 as autoid,@b as empno
union all
select 3 as autoid,@c as empno
union all
select 4 as autoid,@d as empno
union all
select 5 as autoid,@e as empno
)a
select max(autoid) as autoid ,empno
into #bb
from #aa where isnull(empno,'')<>'' group by empno
select empno from #bb order by autoid
drop table #aa
drop table #bb
end
请假申请审核流程2
最新推荐文章于 2024-06-30 12:53:52 发布