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