T-SQL - Schleife

[Devil1925]

Also ich hätte das jetzt so gemacht:

Code:

DECLARE @Counter INT
SET @Counter = 1

WHILE (@Counter < 5)
BEGIN
  Set @C_ID = 
   Case @Counter
   When 1 then @C1_ID else
   When 2 then @C2_ID else
   When 3 then @C3_ID else
   When 4 then @C4_ID end;
END
   SET @Counter = @Counter + 1

MFG Devil