cursor - SQL table : update column with batchName based on the total count of rows

Question

We have a SQL table with few columns and one of the columns is Item. It has various values shown below.

Item
Item1
Item2
Item3
Item4
Item5
Item6
Item7
Item8
Item9
Item10
Item11
Item12

question from:https://stackoverflow.com/questions/65866708/sql-table-update-column-with-batchname-based-on-the-total-count-of-rows

Answer 1

Just use arithmetic. In SQL Server, you can use:

select t.*,
       ( (row_number() over (order by item) + 1) / 2 ) as batch_number
from t