DECLARE@LS_COVGCODE CHAR(3)
DECLARE @LS_EFFDATE DATETIME
DECLARE cur_dep_ben CURSOR FOR
SELECT CHGEFFDATE,COVGCODE FROM TDEPENDENT
WHERE (PRODTYPE ='M' OR PRODTYPE ='L' OR PRODTYPE ='P')
OPEN cur_dep_ben
FETCH cur_dep_benINTO @LS_EFFDATE,@LS_COVGCODE
WHILE @@fetch_status= 0
BEGIN
select * from a_temp
FETCH cur_dep_ben INTO @LS_EFFDATE,@LS_COVGCODE
END
CLOSE cur_dep_ben;
DEALLOCATE cur_dep_ben;
联系客服