update keszlet set mozgaskod='vevo_szle' where mozgaskod='vevo_va'

update mozgas set mozgaskod='vevo_szle' where mozgaskod='vevo_va'

go



/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
go
BEGIN TRANSACTION
GO
ALTER TABLE dbo.kont_szabalyf ADD
	prioritas int NOT NULL CONSTRAINT DF_kont_szabalyf_prioritas DEFAULT 0
GO
COMMIT
go

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[kont_szabalyf_prior_beallit]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[kont_szabalyf_prior_beallit]  

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[kont_szabalyf_prior_beallit] 

WITH RECOMPILE
AS
begin
	declare @tranznev char(32)

	declare @kazon int
	declare @ktip_old int
	declare @ktip int
	declare @X int

	set @tranznev='kont_szabalyf_prior_beallit'
	
	BEGIN TRANSACTION @tranznev

	DECLARE cX CURSOR for 
	SELECT kont_azon,kont_tip FROM kont_szabalyf order by kont_tip, kont_anev for update

	SELECT count(*) FROM kont_szabalyf (holdlock);
	select @X = 0
	select @ktip_old = 0
	open cX
	fetch next from cX into @kazon,@ktip
	while  (@@FETCH_STATUS <> -1)  
	begin
		IF (@@FETCH_STATUS <> -2)
		BEGIN
			if @ktip_old <> @ktip 
			begin
				select @X = 0 
				select @ktip_old = @ktip		
			end
			
			select @X = @X + 1
			update kont_szabalyf set prioritas = @X where current of cX;					
		END
		fetch next from cX into @kazon,@ktip
	end
	close cX
	deallocate cX

	COMMIT TRANSACTION @tranznev

	

end
GO

Exec kont_szabalyf_prior_beallit
GO