แจกไอเท็มคนที่ออนไลน์

Create PROCEDURE [dbo].[Additem_OnlinePlayer] @ItemID int, @QTY int AS BEGIN declare @RowNum int,@CustomerID int select CustomerID into #TempC From UsersData where GameServerId>0 select * from #TempC select @CustomerID=MAX(CustomerID) FROM #TempC --select @CustomerID=CustomerID from #TempC Select @RowNum = Count(*) From #TempC while @RowNum > 0 Begin Exec FN_AddFullItemToUser @CustomerID,@ItemID,@QTY,-1,-1,10000 select top 1 @CustomerID=CustomerID from #TempC where CustomerID < @CustomerID order by CustomerID desc set @RowNum = @RowNum-1 end delete #TempC END