SQL Server Update table, daily data is divided by fixed batch number SQL

UpdateTime by field in the table, numbered every day, numbered from 1, with the table's primary key CID, and storing the data in a temporary table

With temp as
(
SELECT Cid,updatetime,

Row_number () over (PARTITION by CONVERT (varchar), updatetime, and order by UpdateTime) as Row_num

From Customer_transfer
)

Update Batchno from the temporary table according to the primary key CID, giving the numbering setting

UPDATE m SET M.batchno = T.row_num
From customer_transfer m JOIN temp t
On m.cid = T.cid

Renumber daily batch numbers by the rule of a batch number 100

UPDATE customer_transfer SET Batchno = (batchno/100 + 1)