create procedure pd5 @rq datetime,@sj varchar(10), @fh1 varchar(20) output,@sh1 varchar(20) output,@pm1 varchar(20) output as set nocount on --select @fh1=fh,@sh1=sh,@pm1=pm from sy_heihe where rq1=@rq and sj1=@sj and rq2<>@rq select @fh1=fh,@sh1=sh,@pm1=pm from sy_heihe where rq1=@rq and sj1=@sj
@fh1 varchar(20) output,@sh1 varchar(20) output,@pm1 varchar(20) output as
set nocount on
--select @fh1=fh,@sh1=sh,@pm1=pm from sy_heihe where rq1=@rq and sj1=@sj and rq2<>@rq
select @fh1=fh,@sh1=sh,@pm1=pm from sy_heihe where rq1=@rq and sj1=@sj