/*
   2015. november 26.15:30:30
   User: sa
   Server: 192.168.59.120,1450
   Database: aruker
   Application: 
*/

/* 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
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlaf ADD
	iranyito dbo.nev NULL,
	varos dbo.nev NULL,
	cim dbo.nev NULL,
	iso char(2) NULL,
	adoszam dbo.nev NULL
GO
ALTER TABLE dbo.vevo_szlaf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go


update vevo_szlaf set cim=vevok.cim,varos=vevok.varos,iranyito=vevok.iranyito,adoszam=
case when vevok.iso='hu' then vevok.adoszam else vevok.eu_adoszam end, 
iso=vevok.iso
from vevok where vevok.vevo_kod=vevo_szlaf.vevo
go


/*
   2015. november 26.16:07:02
   User: sa
   Server: 192.168.59.120,1450
   Database: aruker
   Application: 
*/

/* 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
BEGIN TRANSACTION
GO
ALTER TABLE dbo.nb_vevo_szlaf ADD
	iranyito dbo.nev NULL,
	varos dbo.nev NULL,
	cim dbo.nev NULL,
	iso char(2) NULL,
	adoszam dbo.nev NULL
GO
ALTER TABLE dbo.nb_vevo_szlaf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go



update nb_vevo_szlaf set cim=vevok.cim,varos=vevok.varos,iranyito=vevok.iranyito,adoszam=
case when vevok.iso='hu' then vevok.adoszam else vevok.eu_adoszam end, 
iso=vevok.iso
from vevok where vevok.vevo_kod=nb_vevo_szlaf.vevo
go



insert into verzio values('upg','Ver. 2.24',dbo.mygetdatetime())
go