游标

--声明游标
DECLARE mycusor CURSOR
FOR SELECT ei.subID,ei.OrderID,ei.ECID,ei.ProductID,ei.TotalLicence,ei.EffectTime,ei.ExpiredTime
 FROM ECSubscriptionInfo ei
 LEFT JOIN SIProductBasicInfo sbi on ei.ProductID=sbi.ProductID
 WHERE sbi.ProductType=2 AND ei.[Status]=0 AND (ei.SyncFlag=4 OR ei.SyncFlag=7) AND ei.ExpiredTime >=GETDATE()

GO
DECLARE @subID INT
DECLARE @orderID INT
DECLARE @ecID INT
DECLARE @productID INT
DECLARE @LicensesNum INT
DECLARE @BeginTime DATETIME
DECLARE @EndTime DATETIME

OPEN mycusor
FETCH NEXT FROM mycusor INTO @subID,@orderID,@ecID,@productID,@LicensesNum,@BeginTime,@EndTime

WHILE @@FETCH_STATUS=0
BEGIN
 INSERT INTO ECSubscriptionExpandInfo
 (
  -- ID -- this column value is auto-generated,
  SubID,
  OrderID,
  ECID,
  ProductID,
  LicensesNum,
  [Status],
  SyncFlag,
  BeginTime,
  Endtime,
  CreateTime
 )
 VALUES
 (
  @subID,@orderID,@ecID,@productID,@LicensesNum,0,4,@BeginTime,@EndTime,GETDATE()
 )
 
 INSERT INTO ECSubscriptionAuthenticationInfo
 (
  -- ID -- this column value is auto-generated,
  SubID,
  ECID,
  ProductID,
  LicensesNum,
  BeginTime,
  Endtime,
  CreateTime
 )
 VALUES
 (
  @subID,@ecID,@productID,@LicensesNum,@BeginTime,@EndTime,GETDATE()
 )
 
 FETCH NEXT FROM mycusor INTO @subID,@orderID,@ecID,@productID,@LicensesNum,@BeginTime,@EndTime
END

--关闭游标
CLOSE mycusor

--删除游标
deallocate  mycusor