Increment a variable while Inserting multiple rows Stored Procedure

Vote count:

0

I am trying to increment a variable while inserting multiple rows.

Here is my last attempt.

DECLARE @i  int
Set @i=0
Insert into winners (ContestantID, DrawingID, SlotNumber) 
SELECT TOP (@Total) ID, @DrawingID, @i + 1  FROM Contestants 
where Drawingid=@DrawingID ORDER BY NEWID()

asked 37 secs ago

Doug Farrell

43

Increment a variable while Inserting multiple rows Stored Procedure