/*
   2010. augusztus 17.10:34:11
   User: sa
   Server: 192.168.1.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
go
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlaf ADD
	BRUTTO_ERTEK dbo.egyseg_ar NOT NULL CONSTRAINT DF_szall_szlaf_BRUTTO_ERTEK DEFAULT 0

GO
COMMIT
go



update szall_szlaf set brutto_ertek=
round((select isnull(SUM(ertek*(100+afaertek)/100),0)
	from vszall_szlat where szall_szlaf.bizszam=vszall_szlat.bizszam),
		CASE penznem WHEN 'HUF' THEN 0 WHEN 'FT' THEN 0 ELSE 2 END)

go