DECLARE @id INT
DECLARE @UserID INT
DECLARE @tt TABLE (id INT IDENTITY(1,1),userid INT)
INSERT INTO @tt(userid)
SELECT UserID FROM dbo.AccountsInfo WHERE SpreaderID>0 AND UserID NOT IN (SELECT UserID FROM QPTreasureDB.dbo.GlobalSpreadInfo WITH(NOLOCK) WHERE UserID IN (SELECT UserID FROM dbo.AccountsInfo WHERE SpreaderID>0))
SELECT TOP 1 @id=id,@UserID=userid FROM @tt
WHILE @@ROWCOUNT>0
BEGIN
INSERT INTO QPTreasureDB.dbo.GlobalSpreadInfo( RegisterGrantScore ,PlayTimeCount ,PlayTimeGrantScore ,FillGrantRate ,BalanceRate ,MinBalanceScore ,UserID ,AddTime ,AlterTime)
SELECT RegisterGrantScore, PlayTimeCount, PlayTimeGrantScore, FillGrantRate, BalanceRate, MinBalanceScore, @UserID, GETDATE(), GETDATE() FROM QPTreasureDB.dbo.GlobalSpreadInfo WHERE ID=1
DELETE FROM @tt WHERE id=@id
SELECT TOP 1 @id=id,@UserID=userid FROM @tt
END