/*
   2014. október 3.11:55:21
   User: sa
   Server: 192.168.59.85,1137
   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
CREATE TABLE dbo.Tmp__web_kosar
	(
	kulcs int NOT NULL IDENTITY (1, 1),
	cikk_szam char(14) NOT NULL,
	cikk_nev varchar(80) NOT NULL,
	brutto_ar numeric(18, 2) NOT NULL,
	netto_ar numeric(18, 2) NOT NULL,
	darab numeric(18, 3) NOT NULL,
	menny_egys varchar(8) NOT NULL,
	afa_kulcs dbo.afa_kulcs NULL,
	gongyoleg_csz dbo.cikk_szam NULL,
	gongyoleg_ar dbo.egyseg_ar NULL,
	akcio varchar(1) NULL,
	vevo_kod int NOT NULL,
	session_id varchar(50) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp__web_kosar SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp__web_kosar ON
GO
IF EXISTS(SELECT * FROM dbo._web_kosar)
	 EXEC('INSERT INTO dbo.Tmp__web_kosar (kulcs, cikk_szam, cikk_nev, brutto_ar, netto_ar, darab, menny_egys, vevo_kod, session_id)
		SELECT kulcs, cikk_szam, cikk_nev, brutto_ar, netto_ar, darab, menny_egys, vevo_kod, session_id FROM dbo._web_kosar WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp__web_kosar OFF
GO
DROP TABLE dbo._web_kosar
GO
EXECUTE sp_rename N'dbo.Tmp__web_kosar', N'_web_kosar', 'OBJECT' 
GO
COMMIT
go

update _web_kosar set afa_kulcs='27', gongyoleg_csz='', gongyoleg_ar=0, akcio=''
go