Código:
DECLARE @Name varchar(10);
DECLARE setLoop CURSOR FOR SELECT Name FROM MuOnline.dbo.Character
OPEN setLoop
FETCH NEXT FROM setLoop INTO @Name
WHILE @@FETCH_STATUS = 0
BEGIN
IF (SELECT AccountID FROM MuOnline.dbo.Character WHERE Name = @Name) = ''
BEGIN
DECLARE @Account varchar(10);
SELECT @Account = Id FROM MuOnline.dbo.AccountCharacter WHERE (GameID1 = @Name OR GameID2 = @Name OR GameID3 = @Name OR GameID4 = @Name OR GameID5 = @Name);
UPDATE MuOnline.dbo.Character SET AccountID = @Account WHERE Name = @Name;
END
FETCH NEXT FROM setLoop INTO @Name
END
CLOSE setLoop
DEALLOCATE setLoop