CREATE TABLE [dbo].[T_Blank](
	[ID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[UserID] [int] NULL,
	[Created] [datetime] NULL,
	[CancelDate] [datetime] NULL
 CONSTRAINT [PK_T_Blank] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

declare @id int
    declare @userId int
    declare @uId int = 0
	declare @setId int = 0
	
	declare  curWorkTable cursor LOCAL fast_forward read_only for
		SELECT ID, UserId from T_Blank
	open curWorkTable
	FETCH NEXT FROM curWorkTable INTO @id, @userId
	WHILE @@FETCH_STATUS = 0
	BEGIN
		if @uId != @userId
			set @setId = @setId + 1
		
		update T_Blank set SetID = @setId
			where ID = @ID
		
		set @uId = @userId
				
		FETCH NEXT FROM curWorkTable INTO @id, @userId
	END
	
	close curWorkTable

UPDATE T SET SetId = sub.cnt
FROM dbo.T_Blank T
inner join
( 
   select ID, count(UserID) as cnt FROM dbo.T_Blank group by ID 
) sub on sub.ID = T.ID 

UPDATE T 
SET SetId = sub.setId
FROM dbo.T_Blank as T
inner join
( 
   select ID, Dense_RANK() OVER(ORDER BY CashierId) as setId
	from dbo.T_Blank 
) sub on sub.ID = T.ID