/*
   2013. március 27.11:30:36
   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
ALTER TABLE dbo.szall_szlef ADD
	brutto_ertek dbo.egyseg_ar NULL
GO
ALTER TABLE dbo.szall_szlef SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go



update szall_szlef set brutto_ertek=(
select isnull(SUM(
(szall_szlet.szorzo * dbo.szall_szlet.edarab * dbo.szall_szlet.EGYSEG_AR) * (100 - dbo.szall_szlet.kedvezmeny) *
(100 - c1.kedvezmeny) * (100 + dbo.afa_kulcs.afaertek) / 1000000),0)
from szall_szlef as c1 inner join szall_szlet on c1.bizszam=szall_szlet.bizszam inner join
afa_kulcs on afa_kulcs.afakulcs=szall_szlet.afa_kulcs
and c1.bizszam=szall_szlef.bizszam)