sqlserver虚拟表的创建，赋值，及循环读取插入值给另一张表

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