DECLARE @intUserID INT,@Amount INT, @Clubid INT,@AmountTmp INT DECLARE cur_ClubHeadCash CURSOR FAST_FORWARD READ_ONLY FOR SELECT userid,cid,cash FROM #temp WHERE userid not in() ORDER BY userid ASC OPEN cur_ClubHeadCash FETCH NEXT FROM cur_ClubHeadCash INTO @intUserID, @Clubid, @Amount WHILE @@FETCH_STATUS = 0 BEGIN
讯享网 
讯享网<span style="color: rgba(0, 0, 255, 1)">PRINT</span> <span style="color: rgba(0, 128, 0, 1)">@intUserID</span> <span style="color: rgba(0, 0, 255, 1)">PRINT</span> <span style="color: rgba(0, 128, 0, 1)">@Clubid</span> <span style="color: rgba(0, 0, 255, 1)">PRINT</span> <span style="color: rgba(0, 128, 0, 1)">@Amount</span> <span style="color: rgba(0, 0, 255, 1)">SET</span> <span style="color: rgba(0, 128, 0, 1)">@AmountTmp</span><span style="color: rgba(128, 128, 128, 1)">=</span> <span style="color: rgba(0, 128, 0, 1)">@Amount</span><span style="color: rgba(128, 128, 128, 1)">*-</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">1</span> <span style="color: rgba(0, 0, 255, 1)">PRINT</span> <span style="color: rgba(0, 128, 0, 1)">@AmountTmp</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)">EXEC dbo.PrPsWeb_UpdateClubCash </span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> @Clubid,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> 13001,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> @AmountTmp,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> '127.0.0.1',</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> '管理员减少房卡',</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> NULL,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> 0</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)">EXEC dbo.PrPsWeb_UpdateUserCash</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> @intUserID,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> 13000,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> @Amount,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> '127.0.0.1',</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> '管理员增加金币',</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> NULL,</span> <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)"> 0 </span> <span style="color: rgba(0, 0, 255, 1)">FETCH</span> <span style="color: rgba(0, 0, 255, 1)">NEXT</span> <span style="color: rgba(0, 0, 255, 1)">FROM</span> cur_ClubHeadCash <span style="color: rgba(0, 0, 255, 1)">INTO</span> <span style="color: rgba(0, 128, 0, 1)">@intUserID</span>,<span style="color: rgba(0, 128, 0, 1)">@Clubid</span>,<span style="color: rgba(0, 128, 0, 1)">@Amount</span> 
 END CLOSE cur_ClubHeadCash DEALLOCATE cur_ClubHeadCash DROP TABLE #temp