34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @Product_Id VARCHAR(128) ,
@Supplier_Id VARCHAR(128),
@DateInProduced VARCHAR(10) ,
@Quantity INT;
DECLARE CUR_ORDER CURSOR
FOR
SELECT Product_Id, Supplier_Id, DateInProduced, Quantity
FROM OrdersTemp
ORDER BY Product_Id , DateInProduced DESC;
OPEN CUR_ORDER;
FETCH NEXT FROM CUR_ORDER INTO @Product_Id, @Supplier_Id, @DateInProduced, @Quantity
WHILE @@FETCH_STATUS = 0
BEGIN
-- 业务逻辑处理........