Update Random Integer Column

[mtepfer]

Have a table with column that contains random integers. Need to reassign a portion of these integers based on certain criteria. I want to start from s specific number then increase the counter by one. Am working with something like this but when I try to increase the counter it will not allow the where statement.

Declare @lottery As int;
Set @lottery = 293300;

update Table
set table Column A = @lottery + 1
set @lottery = @lottery + 1

WHERE Criteria

 

[mtepfer]

Never mind figured it out needed to have set statement as follows :

set @lottery = table column a = @lottery + 1