O2A02 - Machinace s adresarem 2
DELETE FROM #FCADADD^TABULKA#F
GO

INSERT INTO #FCADADD^TABULKA#F (Klic1Adres, Poradi, DicEU, Stat, KodDPHVstu, KoDPVystZb, KoDPVysSlu)
SELECT KLIC1ADR, 1 , 'CZ' + LEFT(RIGHT(DIC, 10), 14) , 'CZ', '', '', ''
FROM #FCADADH^TABULKA#F A00
WHERE (AKTIVITA = 0) AND (RIGHT(LEFT(DIC, 4), 1) = '-')
GO
Z 01.03.2006 O 13.10.2006 DUCHODSERVER