I am getting an error that says "A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations." I know this is occurring when I select @column 2 = cast... But not sure how to fix this. Any suggestions?

```
   declare 
                column1 int = 0,
                column2 int = 0,
                column3 int = 0,
                column4 int = 0,

    insert into dbo.tableName (column1, column2, column3, column4)
        select @column1,
               @column2 = cast((row_number() over(order by column4)) as int),
               @column3,
               @column4,
        from table

```