>Hi!
>
>How can I implement a For... Next in SQL?
>
>Thanks


DECLARE myCursor CURSOR FOR SELECT {your select statement}

OPEN myCursor

FETCH NEXT FROM myCursor INTO @myVar1, @myVar2,...
WHILE @@FETCH_STATUS = 0
BEGIN
{do something here}
FETCH NEXT FROM myCursor INTO @myVar1, @myVar2,...
END
CLOSE myCursor
DEALLOCATE myCursor