Repetir Acción

[dezagus]

Ya lo pude solucionar:

DECLARE @countmin int
DECLARE @countmax int
DECLARE @guild varchar(300)

SET @countmin = (SELECT TOP 1 IDHELPJ FROM UserLogin.dbo.HelPJ ORDER BY IDHELPJ ASC);
SET @countmax = (SELECT TOP 1 IDHELPJ FROM UserLogin.dbo.HelPJ ORDER BY IDHELPJ DESC);

WHILE (@countmin <= @countmax)
BEGIN
SET @guild = (SELECT GuildID FROM Tantra.dbo.TantraBackup00 WHERE UserID = (SELECT IDCUENTA FROM UserLogin.dbo.HelPJ WHERE IDHELPJ = @countmin));
IF @guild != 0
BEGIN
UPDATE UserLogin.dbo.HelPJ SET CLANACTUAL = @guild WHERE IDHELPJ = @countmin;
END
ELSE
BEGIN
UPDATE UserLogin.dbo.HelPJ SET CLANACTUAL = NULL WHERE IDHELPJ = @countmin;
END

SET @countmin = @countmin + 1

END

Me costó pero salio...