-- Mp 07.07.2006
-- Za zamenjavo kontov v tabelah razen tgkGkSk po preslikavni tabeli tsiKOnPlanAnal
-- 1. Postavi Triggerje na tabelah, za katere se dela UPDATE
-- 2. Naredi Update po aktialnih tabelah za tiste vrstice in stolpce, ki še niso zapisani v tfsTabelaLog
-- 3. Drop Triggerjev
-- Če želiš narediti novo preslikavno tabelo, pobriši stolpec NovKontoID in iz tabele tfsTabelaLog pobriši vrstice  WHERE TableAction='K->K'
-- Zaenkrat naredi za vsa podjetje @PID, oziroma pri šifrantih KontoIDP=dbo.PodjetjeOd('tsiKonPlanAnal', vPID)
-- Če je @PID='XX', potem naredi za vsa podjetja. Deklaracijo @PID in prireditev poišči nižje

--*************** DROP TRIGGER ***************DROP TRIGGER ***************DROP TRIGGER ***************
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tsiDavek_Prs' AND type = 'TR')
DROP  TRIGGER tsiDavek_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tsiDDV3Kolona_Prs' AND type = 'TR')
DROP  TRIGGER tsiDDV3Kolona_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tsiVk_Prs' AND type = 'TR')
DROP  TRIGGER tsiVk_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tblaBesedilo_Prs' AND type = 'TR')
DROP  TRIGGER tblaBesedilo_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tblaNastavitev_Prs' AND type = 'TR')
DROP  TRIGGER tblaNastavitev_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tblaPostavka_Prs' AND type = 'TR')
DROP  TRIGGER tblaPostavka_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tfaPostavka_Prs' AND type = 'TR')
DROP  TRIGGER tfaPostavka_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tfaStoritev_Prs' AND type = 'TR')
DROP  TRIGGER tfaStoritev_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tfaVk_Prs' AND type = 'TR')
DROP  TRIGGER tfaVk_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosAmorSkup_Prs' AND type = 'TR')
DROP  TRIGGER tosAmorSkup_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosKplan_Prs' AND type = 'TR')
DROP  TRIGGER tosKplan_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosOsn_Prs' AND type = 'TR')
DROP  TRIGGER tosOsn_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosNastavitev_Prs' AND type = 'TR')
DROP  TRIGGER tosNastavitev_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tbpKontiranje_Prs' AND type = 'TR')
DROP  TRIGGER tbpKontiranje_Prs
go

--*************** CREATE TRIGGER *************** CREATE TRIGGER ***************CREATE TRIGGER **********

CREATE TRIGGER tsiDavek_Prs
ON tsiDavek FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tsiDavek zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tsiDavek'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On

INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoKpID',  Deleted.KontoKpID, Inserted.KontoKpID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoKpID, '')<>IsNull(Inserted.KontoKpID, '')
go

CREATE TRIGGER tsiDDV3Kolona_Prs
ON tsiDDV3Kolona FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tsiDDV3Kolona zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tsiDDV3Kolona'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
go


CREATE TRIGGER tsiVk_Prs
ON tsiVk FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tsiVk zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tsiVk'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'ProtiKonto',  Deleted.ProtiKonto, Inserted.ProtiKonto  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.ProtiKonto, '')<>IsNull(Inserted.ProtiKonto, '')
go

CREATE TRIGGER tblaBesedilo_Prs
ON tblaBesedilo FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tblaBesedilo zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tblaBesedilo'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoStr',  Deleted.KontoStr, Inserted.KontoStr  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoStr, '')<>IsNull(Inserted.KontoStr, '')
go

CREATE TRIGGER tblaNastavitev_Prs
ON tblaNastavitev FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tblaNastavitev zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tblaNastavitev'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoPrehodniBLI',  Deleted.KontoPrehodniBLI, Inserted.KontoPrehodniBLI  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoPrehodniBLI, '')<>IsNull(Inserted.KontoPrehodniBLI, '')
go

CREATE TRIGGER tblaPostavka_Prs
ON tblaPostavka FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tblaPostavka zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tblaPostavka'
Select @PKName= 'Kljuc'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoDDV',  Deleted.KontoDDV, Inserted.KontoDDV  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoDDV, '')<>IsNull(Inserted.KontoDDV, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoEvd',  Deleted.KontoEvd, Inserted.KontoEvd  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoEvd, '')<>IsNull(Inserted.KontoEvd, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoProtiEvd',  Deleted.KontoProtiEvd, Inserted.KontoProtiEvd  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoProtiEvd, '')<>IsNull(Inserted.KontoProtiEvd, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoDob',  Deleted.KontoDob, Inserted.KontoDob  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoDob, '')<>IsNull(Inserted.KontoDob, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoStr',  Deleted.KontoStr, Inserted.KontoStr  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoStr, '')<>IsNull(Inserted.KontoStr, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoDDVNeOdbitni',  Deleted.KontoDDVNeOdbitni, Inserted.KontoDDVNeOdbitni  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoDDVNeOdbitni, '')<>IsNull(Inserted.KontoDDVNeOdbitni, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Kljuc, 'KontoBlagajneID',  Deleted.KontoBlagajneID, Inserted.KontoBlagajneID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Kljuc=DELETED.Kljuc WHERE  IsNull(Deleted.KontoBlagajneID, '')<>IsNull(Inserted.KontoBlagajneID, '')
go

CREATE TRIGGER tfaPostavka_Prs
ON tfaPostavka FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tfaPostavka zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tfaPostavka'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'k1',  Deleted.k1, Inserted.k1  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.k1, '')<>IsNull(Inserted.k1, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'K2',  Deleted.K2, Inserted.K2  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.K2, '')<>IsNull(Inserted.K2, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'PK1',  Deleted.PK1, Inserted.PK1  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.PK1, '')<>IsNull(Inserted.PK1, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'PK2',  Deleted.PK2, Inserted.PK2  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.PK2, '')<>IsNull(Inserted.PK2, '')
go


CREATE TRIGGER tfaStoritev_Prs
ON tfaStoritev FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tfaStoritev zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tfaStoritev'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoDz',  Deleted.KontoDz, Inserted.KontoDz  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoDz, '')<>IsNull(Inserted.KontoDz, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'ProtiKontoDz',  Deleted.ProtiKontoDz, Inserted.ProtiKontoDz  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.ProtiKontoDz, '')<>IsNull(Inserted.ProtiKontoDz, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoNz',  Deleted.KontoNz, Inserted.KontoNz  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoNz, '')<>IsNull(Inserted.KontoNz, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'ProtiKontoNz',  Deleted.ProtiKontoNz, Inserted.ProtiKontoNz  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.ProtiKontoNz, '')<>IsNull(Inserted.ProtiKontoNz, '')
go

CREATE TRIGGER tfaVk_Prs
ON tfaVk FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tfaVk zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tfaVk'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'K1',  Deleted.K1, Inserted.K1  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.K1, '')<>IsNull(Inserted.K1, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Pk1',  Deleted.Pk1, Inserted.Pk1  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Pk1, '')<>IsNull(Inserted.Pk1, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'K1Nz',  Deleted.K1Nz, Inserted.K1Nz  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.K1Nz, '')<>IsNull(Inserted.K1Nz, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Pk1Nz',  Deleted.Pk1Nz, Inserted.Pk1Nz  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Pk1Nz, '')<>IsNull(Inserted.Pk1Nz, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoIDZR',  Deleted.KontoIDZR, Inserted.KontoIDZR  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoIDZR, '')<>IsNull(Inserted.KontoIDZR, '')
go

CREATE TRIGGER tosAmorSkup_Prs
ON tosAmorSkup FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tosAmorSkup zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tosAmorSkup'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoNabaveID',  Deleted.KontoNabaveID, Inserted.KontoNabaveID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoNabaveID, '')<>IsNull(Inserted.KontoNabaveID, '')
go

CREATE TRIGGER tosKplan_Prs
ON tosKplan FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tosKplan zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tosKplan'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KPv',  Deleted.KPv, Inserted.KPv  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KPv, '')<>IsNull(Inserted.KPv, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KPvMl',  Deleted.KPvMl, Inserted.KPvMl  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KPvMl, '')<>IsNull(Inserted.KPvMl, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KMrvAo',  Deleted.KMrvAo, Inserted.KMrvAo  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KMrvAo, '')<>IsNull(Inserted.KMrvAo, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KMrvPv',  Deleted.KMrvPv, Inserted.KMrvPv  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KMrvPv, '')<>IsNull(Inserted.KMrvPv, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KMamMin',  Deleted.KMamMin, Inserted.KMamMin  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KMamMin, '')<>IsNull(Inserted.KMamMin, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KMamPov',  Deleted.KMamPov, Inserted.KMamPov  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KMamPov, '')<>IsNull(Inserted.KMamPov, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KRam',  Deleted.KRam, Inserted.KRam  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KRam, '')<>IsNull(Inserted.KRam, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KRamPov',  Deleted.KRamPov, Inserted.KRamPov  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KRamPov, '')<>IsNull(Inserted.KRamPov, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KUcinMrv',  Deleted.KUcinMrv, Inserted.KUcinMrv  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KUcinMrv, '')<>IsNull(Inserted.KUcinMrv, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KUcinRam',  Deleted.KUcinRam, Inserted.KUcinRam  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KUcinRam, '')<>IsNull(Inserted.KUcinRam, '')
go

CREATE TRIGGER tosOsn_Prs
ON tosOsn FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tosOsn zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tosOsn'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoNabaveID',  Deleted.KontoNabaveID, Inserted.KontoNabaveID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoNabaveID, '')<>IsNull(Inserted.KontoNabaveID, '')
go

CREATE TRIGGER tosNastavitev_Prs
ON tosNastavitev FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tosNastavitev zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tosNastavitev'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoID',  Deleted.KontoID, Inserted.KontoID  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoID, '')<>IsNull(Inserted.KontoID, '')
go


CREATE TRIGGER tbpKontiranje_Prs
ON tbpKontiranje FOR UPDATE

NOT FOR REPLICATION

AS
-- Mp 01.07.2006 Beleži spremembe tabele tbpKontiranje zaradi sprememb na nove konte
Declare @TableName varchar(50)
Declare @PKName varchar(50)
Declare @CurrentUser nVarChar(20)
Declare @UpdateDate datetime
Declare @Workstation Varchar(50)
Declare @sAction VarChar(10)

Select @TableName= 'tbpKontiranje'
Select @PKName= 'Zaporedje'
Select @CurrentUser = system_user
Select @UpdateDate = convert(varchar(8), getdate(), 112) + ' ' + convert(varchar(8), getdate(), 108)
Select @Workstation = host_name()

IF @@RowCount <> 1 
   Return

SET NoCount On
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto220',  Deleted.Konto220, Inserted.Konto220  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto220, '')<>IsNull(Inserted.Konto220, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto660',  Deleted.Konto660, Inserted.Konto660  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto660, '')<>IsNull(Inserted.Konto660, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto660Izd',  Deleted.Konto660Izd, Inserted.Konto660Izd  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto660Izd, '')<>IsNull(Inserted.Konto660Izd, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto710',  Deleted.Konto710, Inserted.Konto710  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto710, '')<>IsNull(Inserted.Konto710, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto163',  Deleted.Konto163, Inserted.Konto163  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto163, '')<>IsNull(Inserted.Konto163, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto783',  Deleted.Konto783, Inserted.Konto783  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto783, '')<>IsNull(Inserted.Konto783, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto280',  Deleted.Konto280, Inserted.Konto280  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto280, '')<>IsNull(Inserted.Konto280, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoN280',  Deleted.KontoN280, Inserted.KontoN280  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoN280, '')<>IsNull(Inserted.KontoN280, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto120',  Deleted.Konto120, Inserted.Konto120  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto120, '')<>IsNull(Inserted.Konto120, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto761KP',  Deleted.Konto761KP, Inserted.Konto761KP  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto761KP, '')<>IsNull(Inserted.Konto761KP, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto771',  Deleted.Konto771, Inserted.Konto771  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto771, '')<>IsNull(Inserted.Konto771, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoRVC',  Deleted.KontoRVC, Inserted.KontoRVC  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoRVC, '')<>IsNull(Inserted.KontoRVC, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto759',  Deleted.Konto759, Inserted.Konto759  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto759, '')<>IsNull(Inserted.Konto759, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto799',  Deleted.Konto799, Inserted.Konto799  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto799, '')<>IsNull(Inserted.Konto799, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto990',  Deleted.Konto990, Inserted.Konto990  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto990, '')<>IsNull(Inserted.Konto990, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'Konto995',  Deleted.Konto995, Inserted.Konto995  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.Konto995, '')<>IsNull(Inserted.Konto995, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoEU7',  Deleted.KontoEU7, Inserted.KontoEU7  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoEU7, '')<>IsNull(Inserted.KontoEU7, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoEU8',  Deleted.KontoEU8, Inserted.KontoEU8  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoEU8, '')<>IsNull(Inserted.KontoEU8, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoEU9',  Deleted.KontoEU9, Inserted.KontoEU9  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoEU9, '')<>IsNull(Inserted.KontoEU9, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoDi350',  Deleted.KontoDi350, Inserted.KontoDi350  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoDi350, '')<>IsNull(Inserted.KontoDi350, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoDi351',  Deleted.KontoDi351, Inserted.KontoDi351  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoDi351, '')<>IsNull(Inserted.KontoDi351, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoDi357',  Deleted.KontoDi357, Inserted.KontoDi357  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoDi357, '')<>IsNull(Inserted.KontoDi357, '')
INSERT INTO tfsTabelaLog (recDateTime, WorkstationID, CurrentUser, TableName, TableAction, recIDField, recID, FieldName, OldValue, NewValue)SELECT @UpdateDate, @Workstation, @CurrentUser, @TableName,'K->K', @PKName, Inserted.Zaporedje, 'KontoDi405',  Deleted.KontoDi405, Inserted.KontoDi405  FROM INSERTED INNER JOIN DELETED ON INSERTED.Zaporedje=DELETED.Zaporedje WHERE  IsNull(Deleted.KontoDi405, '')<>IsNull(Inserted.KontoDi405, '')
go

-- ***************** UPDATE *************** UPDATE ***************UPDATE ***************UPDATE ***************
DECLARE @PID nVarChar(2), @KontoIDP nVarChar(2)
SET @PID='02'
SET @KontoIDP=dbo.PodjetjeOd('tsiKonPlanAnal', @PID)

-- tsiDavek--------------------------------------------------------
UPDATE tsiDavek SET KontoID = Kpl.NovKontoID
FROM  dbo.tsiDavek t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tsiDavek' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tsiDavek SET KontoKpID = Kpl.NovKontoID
FROM  dbo.tsiDavek t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoKpID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog log ON 'tsiDavek' = Log.TableName AND 'KontoKpID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)


-- tsiDDV3Kolona --------------------------------------------------------
UPDATE tsiDDV3Kolona SET KontoID = Kpl.NovKontoID
FROM  dbo.tsiDDV3Kolona t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tsiDDV3Kolona' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)


-- tsiVk --------------------------------------------------------
UPDATE tsiVk SET KontoID = Kpl.NovKontoID
FROM  dbo.tsiVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tsiVk' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tsiVk SET ProtiKonto = Kpl.NovKontoID
FROM  dbo.tsiVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.ProtiKonto = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog log ON 'tsiVk' = Log.TableName AND 'ProtiKonto' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)


-- tblaBesedilo --------------------------------------------------------
UPDATE tblaBesedilo SET KontoID = Kpl.NovKontoID
FROM  dbo.tblaBesedilo t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaBesedilo' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tblaBesedilo SET KontoStr = Kpl.NovKontoID
FROM  dbo.tblaBesedilo t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoStr = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog log ON 'tblaBesedilo' = Log.TableName AND 'KontoStr' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)


-- tblaNastavitev --------------------------------------------------------
UPDATE tblaNastavitev SET KontoID = Kpl.NovKontoID
FROM  dbo.tblaNastavitev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaNastavitev' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaNastavitev SET KontoPrehodniBLI = Kpl.NovKontoID
FROM  dbo.tblaNastavitev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoPrehodniBLI = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog log ON 'tblaNastavitev' = Log.TableName AND 'KontoPrehodniBLI' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)


-- tblaPostavka --------------------------------------------------------
UPDATE tblaPostavka SET KontoID = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoDDV = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoDDV = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog log ON 'tblaPostavka' = Log.TableName AND 'KontoDDV' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoEvd = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoEvd = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoEvd' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoProtiEvd = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoProtiEvd = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoProtiEvd' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoDob = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoDob = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoDob' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoStr = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoStr = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoStr' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoDDVNeOdbitni = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoDDVNeOdbitni = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoDDVNeOdbitni' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tblaPostavka SET KontoBlagajneID = Kpl.NovKontoID
FROM  dbo.tblaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoBlagajneID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tblaPostavka' = Log.TableName AND 'KontoBlagajneID' = Log.FieldName AND t.Kljuc = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)


-- tfaPostavka --------------------------------------------------------
UPDATE tfaPostavka SET K1 = Kpl.NovKontoID
FROM  dbo.tfaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.K1 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaPostavka' = Log.TableName AND 'K1' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tfaPostavka SET K2 = Kpl.NovKontoID
FROM  dbo.tfaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.K2 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaPostavka' = Log.TableName AND 'K2' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tfaPostavka SET PK1 = Kpl.NovKontoID
FROM  dbo.tfaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.PK1 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaPostavka' = Log.TableName AND 'PK1' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tfaPostavka SET PK2 = Kpl.NovKontoID
FROM  dbo.tfaPostavka t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.PK2 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaPostavka' = Log.TableName AND 'PK2' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)


-- tfaStoritev --------------------------------------------------------
UPDATE tfaStoritev SET KontoDZ = Kpl.NovKontoID
FROM  dbo.tfaStoritev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoDZ = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaStoritev' = Log.TableName AND 'KontoDZ' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaStoritev SET ProtiKontoDZ = Kpl.NovKontoID
FROM  dbo.tfaStoritev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.ProtiKontoDZ = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaStoritev' = Log.TableName AND 'ProtiKontoDZ' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaStoritev SET KontoNz = Kpl.NovKontoID
FROM  dbo.tfaStoritev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoNz = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaStoritev' = Log.TableName AND 'KontoNz' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaStoritev SET ProtiKontoNz = Kpl.NovKontoID
FROM  dbo.tfaStoritev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.ProtiKontoNz = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaStoritev' = Log.TableName AND 'ProtiKontoNz' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

-- tfaVk --------------------------------------------------------
UPDATE tfaVk SET K1 = Kpl.NovKontoID
FROM  dbo.tfaVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.K1 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaVk' = Log.TableName AND 'K1' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaVk SET Pk1 = Kpl.NovKontoID
FROM  dbo.tfaVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.Pk1 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaVk' = Log.TableName AND 'Pk1' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaVk SET K1Nz = Kpl.NovKontoID
FROM  dbo.tfaVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.K1Nz = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaVk' = Log.TableName AND 'K1Nz' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaVk SET PK1Nz = Kpl.NovKontoID
FROM  dbo.tfaVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.PK1Nz = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaVk' = Log.TableName AND 'PK1Nz' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tfaVk SET KontoIDZR = Kpl.NovKontoID
FROM  dbo.tfaVk t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoIDZR = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tfaVk' = Log.TableName AND 'KontoIDZR' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

-- tosAmorSkup --------------------------------------------------------
UPDATE tosAmorSkup SET KontoID = Kpl.NovKontoID
FROM  dbo.tosAmorSkup t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosAmorSkup' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosAmorSkup SET KontoNabaveID = Kpl.NovKontoID
FROM  dbo.tosAmorSkup t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoNabaveID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosAmorSkup' = Log.TableName AND 'KontoNabaveID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

-- tosKplan --------------------------------------------------------
UPDATE tosKplan SET KontoID = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KPv = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KPv = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KPv' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KPvMl = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KPvMl = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KPvMl' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KMrvAo = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KMrvAo = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KMrvAo' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KMrvPv = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KMrvPv = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KMrvPv' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KMamMin = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KMamMin = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KMamMin' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KMamPov = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KMamPov = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KMamPov' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KRam = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KRam = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KRam' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KRamPov = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KRamPov = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KRamPov' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KUcinMrv = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KUcinMrv = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KUcinMrv' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

UPDATE tosKplan SET KUcinRam = Kpl.NovKontoID
FROM  dbo.tosKplan t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KUcinRam = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosKplan' = Log.TableName AND 'KUcinRam' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontoIDP=@KontoIDP)

-- tosOsn --------------------------------------------------------
UPDATE tosOsn SET KontoID = Kpl.NovKontoID
FROM  dbo.tosOsn t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosOsn' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

UPDATE tosOsn SET KontoNabaveID = Kpl.NovKontoID
FROM  dbo.tosOsn t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoNabaveID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosOsn' = Log.TableName AND 'KontoNabaveID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

-- tosNastavitev --------------------------------------------------------
UPDATE tosNastavitev SET KontoID = Kpl.NovKontoID
FROM  dbo.tosNastavitev t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontoIDP = Kpl.KontoIDP AND t.KontoID = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tosNastavitev' = Log.TableName AND 'KontoID' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0) AND (Log.RecID IS NULL) AND (@PID='XX' OR t.PID=@PID)

-- tbpKontiranje --------------------------------------------------------
UPDATE tbpKontiranje SET Konto220 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto220 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto220' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto660 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto660 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto660' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto660Izd = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto660Izd = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto660Izd' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto710 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto710 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto710' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto163 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto163 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto163' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto783 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto783 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto783' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto280 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto280 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto280' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoN280 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoN280 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoN280' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto120 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto120 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto120' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto761KP = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto761KP = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto761KP' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto771 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto771 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto771' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoRVC = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoRVC = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoRVC' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto759 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto759 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto759' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto799 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto799 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto799' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto990 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto990 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto990' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET Konto995 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.Konto995 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'Konto995' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoEU7 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoEU7 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoEU7' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoEU8 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoEU8 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoEU8' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoEU9 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoEU9 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoEU9' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoDi350 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoDi350 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoDi350' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoDi351 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoDi351 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoDi351' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoDi357 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoDi357 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoDi357' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

UPDATE tbpKontiranje SET KontoDi405 = Kpl.NovKontoID
FROM  dbo.tbpKontiranje t INNER JOIN
               dbo.tsiKonPlanAnal Kpl ON t.KontiranjeIDP = Kpl.KontoIDP AND t.KontoDi405 = Kpl.KontoID LEFT OUTER JOIN
               dbo.tfsTabelaLog Log ON 'tbpKontiranje' = Log.TableName AND 'KontoDi405' = Log.FieldName AND t.Zaporedje = Log.RecID
WHERE (dbo.Emp(Kpl.NovKontoID) = 0)AND (Log.RecID IS NULL) AND (@KontoIDP='XX' OR t.KontiranjeIDP=@KontoIDP)

--*************** DROP TRIGGER ***************DROP TRIGGER ***************DROP TRIGGER ***************
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tsiDavek_Prs' AND type = 'TR')
DROP  TRIGGER tsiDavek_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tsiVk_Prs' AND type = 'TR')
DROP  TRIGGER tsiVk_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tblaBesedilo_Prs' AND type = 'TR')
DROP  TRIGGER tblaBesedilo_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tblaNastavitev_Prs' AND type = 'TR')
DROP  TRIGGER tblaNastavitev_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tblaPostavka_Prs' AND type = 'TR')
DROP  TRIGGER tblaPostavka_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tfaPostavka_Prs' AND type = 'TR')
DROP  TRIGGER tfaPostavka_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tfaStoritev_Prs' AND type = 'TR')
DROP  TRIGGER tfaStoritev_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tfaVk_Prs' AND type = 'TR')
DROP  TRIGGER tfaVk_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosAmorSkup_Prs' AND type = 'TR')
DROP  TRIGGER tosAmorSkup_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosKplan_Prs' AND type = 'TR')
DROP  TRIGGER tosKplan_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosOsn_Prs' AND type = 'TR')
DROP  TRIGGER tosOsn_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tosNastavitev_Prs' AND type = 'TR')
DROP  TRIGGER tosNastavitev_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tsiDDV3Kolona_Prs' AND type = 'TR')
DROP  TRIGGER tsiDDV3Kolona_Prs
go
IF EXISTS (SELECT name FROM sysobjects   WHERE name = 'tbpKontiranje_Prs' AND type = 'TR')
DROP  TRIGGER tbpKontiranje_Prs
go