DECLARE auth_cur CURSOR FOR
SELECT MIBH,SPDM FROM LYRJDMX WHERE DJBH=@DJBH
open auth_cur
fetch next from auth_cur into @MIBH,@SPDM
while (@@fetch_status=0)
BEGIN
fetch next from auth_cur into @MIBH,@SPDM
END
close auth_cur
deallocate auth_cur
SELECT MIBH,SPDM FROM LYRJDMX WHERE DJBH=@DJBH
open auth_cur
fetch next from auth_cur into @MIBH,@SPDM
while (@@fetch_status=0)
BEGIN
fetch next from auth_cur into @MIBH,@SPDM
END
close auth_cur
deallocate auth_cur