Šī ir veca dokumenta versija!
Code versions test
ALTER PROCEDURE [dbo].[xml_core_SISSE] AS DECLARE @klient_kood BIGINT, @kood BIGINT, @nimitmp nvarchar(255),@addrtmp nvarchar(255),@konttmp nvarchar(255), @koodid VARCHAR(1000) DECLARE @ladu nvarchar(32), @seeria nvarchar(32), @objekt nvarchar(32), @s1 INT, @s2 INT, @webid nvarchar(32), @webtype nvarchar(32) DECLARE @NUMBER INT, @maa INT, @kmk nvarchar(32), @x INT, @kinnitatud INT DECLARE @myyja nvarchar(32), @aeg datetime DECLARE @KEY nvarchar(32) DECLARE @web_kood nvarchar(32), @objkood nvarchar(32), @suletud nvarchar(32) DECLARE @fintype nvarchar(32) DECLARE @result1 xml, @result2 nvarchar(MAX) DECLARE @artikkel nvarchar(32), @id_exist INT DECLARE @kl_kood nvarchar(32), @nimi nvarchar(255), @kustuta INT, @appkey nvarchar(64), @appkey_event nvarchar(64),@ext_id nvarchar(32) DECLARE @sims_kood nvarchar(32), @projekt nvarchar(32), @event BIGINT, @event_id nvarchar(32) DECLARE @koer nvarchar(MAX) DECLARE @ag datetime DECLARE @fcomment nvarchar(255) DECLARE @err nvarchar(32) SET nocount ON; SET @KEY=CONVERT(nvarchar(MAX),getdate(),121) UPDATE in_kliendid2 SET x=@KEY WHERE x IS NULL --customers in UPDATE in_artiklid2 SET x=@KEY WHERE x IS NULL --items in UPDATE in_tell_tellimused2 SET x=@KEY WHERE x IS NULL --items in UPDATE in_mr_arved2 SET x=@KEY WHERE x IS NULL --items in UPDATE in_ladu_sissetulekud SET x=@KEY WHERE x IS NULL --items in CREATE TABLE #changes ( kood nvarchar(32), FIELD nvarchar(32), enne nvarchar(255), nyyd nvarchar(255), cu nvarchar(32), aeg datetime ) CREATE TABLE #results (NUMBER nvarchar(32), tyyp nvarchar(32), RESULT INT, descr nvarchar(255), submittype nvarchar(32), ext_id nvarchar(32)) SELECT @appkey=setting FROM settings WITH(nolock) WHERE [id]='xmlcore_key' DECLARE customers cursor FOR SELECT kood, appkey FROM in_kliendid2 WHERE x=@KEY OPEN customers FETCH NEXT FROM customers INTO @webid, @appkey_event WHILE @@FETCH_STATUS = 0 BEGIN SET @kl_kood=@webid IF @appkey_event=@appkey BEGIN IF (SELECT COUNT(kood) FROM kliendid WITH(nolock) WHERE kood=@webid)=0 BEGIN IF (SELECT COUNT(kood) FROM pangad WHERE kood=(SELECT pank_swift FROM in_kliendid2 WHERE kood=@webid AND x=@KEY))=0 BEGIN INSERT pangad (kood, nimi, swift) SELECT pank_swift, pank_nimi, pank_swift FROM in_kliendid2 WHERE kood=@webid AND x=@KEY END INSERT kliendid ( kood , nimi , kmregnr , regnr , aadress1 , aadress2 , aadress3 , lahaadress1 , lahaadress2 , lahaadress3 , pank , arveldusarve ) SELECT kood , nimi , kmregnr , regnr , aadress1 , aadress2 , aadress3 , lahaadress1 , lahaadress2 , lahaadress3 , pank_swift , pank_iban FROM in_kliendid2 WHERE kood=@webid INSERT INTO #results VALUES (@kl_kood, 'Customer', 0, 'CREATED','Customers',@webid) END ELSE BEGIN IF (SELECT COUNT(kood) FROM pangad WHERE kood=(SELECT pank_swift FROM in_kliendid2 WHERE kood=@webid AND x=@KEY))=0 BEGIN INSERT pangad (kood, nimi, swift) SELECT pank_swift, pank_nimi, pank_swift FROM in_kliendid2 WHERE kood=@webid AND x=@KEY END INSERT #changes SELECT kood, 'aadress1', aadress1, (SELECT aadress1 FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'aadress2', aadress2, (SELECT aadress2 FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'aadress3', aadress3, (SELECT aadress3 FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'nimi', nimi, (SELECT nimi FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'lahaadress1', lahaadress1, (SELECT lahaadress1 FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'lahaadress2', lahaadress2, (SELECT lahaadress2 FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'lahaadress3', lahaadress3, (SELECT lahaadress3 FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'pank', pank, (SELECT pank_swift FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'arveldusarve', arveldusarve, (SELECT pank_iban FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'regnr', regnr, (SELECT regnr FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid UNION SELECT kood, 'kmregnr', kmregnr, (SELECT kmregnr FROM in_kliendid2 WHERE kood=@webid AND x=@KEY), 'xmlcore', getdate() FROM kliendid WHERE kood=@webid INSERT kliendid_ajalugu (kood, aeg, FIELD, enne, nyyd, cu) SELECT kood, aeg, FIELD, enne, nyyd, cu FROM #changes WHERE enne!=nyyd AND kood=@webid UPDATE kliendid SET nimi=z.nimi , aadress1=z.aadress1 , aadress2=z.aadress2 , aadress3=z.aadress3 , lahaadress1=z.lahaadress1 , lahaadress2=z.lahaadress2 , lahaadress3=z.lahaadress3 , pank=z.pank_swift , arveldusarve=z.pank_iban , regnr=z.regnr , kmregnr=z.kmregnr , cu='xmlcore' , ts=getdate() FROM (SELECT * FROM in_kliendid2 WHERE kood=@webid AND x=@KEY) z WHERE kliendid.kood=@webid /* insert artiklid_ajalugu (kood, aeg, field, enne, nyyd, cu) select kood, aeg, field, enne, nyyd, cu from #changes where enne!=nyyd */ INSERT INTO #results VALUES (@kl_kood, 'Customer', 1, 'UPDATED','Customers',@webid) END END ELSE BEGIN INSERT INTO #results VALUES (NULL, 'Customer', 2, 'Incorrect AppKey','Customers',@webid) END SET @x=@x+1 FETCH NEXT FROM customers INTO @webid, @appkey_event END CLOSE customers DEALLOCATE customers DECLARE items cursor FOR SELECT kood, appkey FROM in_artiklid2 WHERE x=@KEY OPEN items FETCH NEXT FROM items INTO @webid, @appkey_event WHILE @@FETCH_STATUS = 0 BEGIN SET @kl_kood=@webid IF @appkey_event=@appkey BEGIN IF (SELECT COUNT(kood) FROM artiklid WHERE kood=@webid)=0 BEGIN INSERT artiklid ( kood , nimi , klass , baashind , yhik , ts , cu ) SELECT kood , nimi , klass , CONVERT(money,hind) , yhik , getdate() , 'xmlcore' FROM in_artiklid2 WHERE kood=@webid INSERT INTO #results VALUES (@kl_kood, 'Item', 0, 'CREATED','Items',@webid) END ELSE BEGIN INSERT #changes SELECT kood, 'nimi', nimi, (SELECT nimi FROM in_artiklid2 WHERE kood=@webid), 'xmlcore', getdate() FROM artiklid WHERE kood=@webid UNION SELECT kood, 'klass', klass, (SELECT klass FROM in_artiklid2 WHERE kood=@webid), 'xmlcore', getdate() FROM artiklid WHERE kood=@webid UNION SELECT kood, 'hind', CONVERT(nvarchar(MAX),baashind), (SELECT CONVERT(nvarchar(MAX),hind) FROM in_artiklid2 WHERE kood=@webid), 'xmlcore', getdate() FROM artiklid WHERE kood=@webid UNION SELECT kood, 'yhik', yhik, (SELECT yhik FROM in_artiklid2 WHERE kood=@webid), 'xmlcore', getdate() FROM artiklid WHERE kood=@webid UPDATE artiklid SET nimi=z.nimi , klass=z.klass , baashind=z.hind , yhik=z.yhik FROM (SELECT * FROM in_artiklid2 WHERE kood=@webid) z WHERE artiklid.kood=z.kood INSERT INTO #results VALUES (@kl_kood, 'Item', 1, 'UPDATED','Items',@webid) END END ELSE BEGIN INSERT INTO #results VALUES (NULL, 'Item', 2, 'Incorrect AppKey','Items',@webid) END SET @x=@x+1 FETCH NEXT FROM items INTO @webid, @appkey_event END CLOSE items DEALLOCATE items DECLARE orders cursor FOR SELECT CONVERT(nvarchar(MAX),NUMBER), appkey FROM in_tell_tellimused2 WHERE x=@KEY OPEN orders FETCH NEXT FROM orders INTO @webid, @appkey_event WHILE @@FETCH_STATUS = 0 BEGIN SET @kl_kood=@webid IF @appkey_event=@appkey BEGIN IF (SELECT COUNT(NUMBER) FROM tell_tellimused WHERE kliendi_tellimus=@webid)=0 BEGIN EXEC dbo.get_dok_number @moodul='tellimus', @seeria='VEIKALIEMLV', @NUMBER = NULL, @cu='xmlcore', @aeg=@ag, @keel = 'default', @num =@NUMBER OUTPUT, @err = @err OUTPUT UPDATE tell_tellimused SET kliendi_tellimus=@webid ,klient_kood=z.klient_kood ,klient_nimi=z.klient_nimi ,arvetasub=z.arvetasub ,lahetusaadress1=z.lahetusaadress1 ,lahetusaadress2=z.lahetusaadress2 ,lahetusaadress3=z.lahetusaadress3 ,lisa_field1=CASE WHEN (z.deal_type = '1') THEN N'Preču pārdošana' WHEN (z.deal_type = '2') THEN N'Pakalpojuma sniegšana' ELSE N'Preču piegāde' END ,aeg=z.aeg ,tingimus=z.tingimus ,kommentaar=z.kommentaar ,myyja=z.myyja ,summa=z.summa ,kmkokku=z.kmkokku ,summakokku=z.summakokku ,tell_tyyp=z.deal_type ,ettemaks=z.prepayment FROM (SELECT klient_kood,klient_nimi,arvetasub,lahetusaadress1,lahetusaadress2,lahetusaadress3,deal_type,aeg,tingimus,kommentaar,myyja,summa,kmkokku,summakokku,prepayment FROM in_tell_tellimused2 WHERE NUMBER=@webid)z WHERE tell_tellimused.number=@NUMBER SELECT @maa = isnull(maa,0) FROM kliendid WHERE kood=(SELECT klient_kood FROM tell_tellimused WHERE NUMBER=@NUMBER) INSERT tell_tellimused_read ( NUMBER ,rn ,rv ,artikkel ,nimetus ,kogus ,yhik ,yhikuhind ,rv_summa ,summa ,myygikate ,konto ,kmkood ) SELECT @NUMBER ,rn ,rn ,artikkel ,nimetus ,kogus ,yhik ,yhikuhind ,rsum ,rsum ,rsum ,CASE WHEN (@maa = 0) THEN isnull((SELECT konto_myyk FROM artiklid WHERE kood=artikkel),(SELECT myyk_eestis FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) WHEN (@maa = 1) THEN isnull((SELECT konto_myyk_EU FROM artiklid WHERE kood=artikkel),(SELECT myyk_eu FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) END AS konto /*,iif( isnull(kmkood,'')!='',kmkood,(case when (@maa = 0) then isnull((select KMkood from artiklid where kood=artikkel),(select kmk_eesti from artikliklassid where kood=(select klass from artiklid where kood=artikkel))) when (@maa = 1) then isnull((select KMkood_EU from artiklid where kood=artikkel),(select kmk_eu from artikliklassid where kood=(select klass from artiklid where kood=artikkel))) end )) as kmkood*/ ,iif(isnumeric(kmkood)=1,kmkood,(CASE WHEN (@maa = 0) THEN isnull((SELECT KMkood FROM artiklid WHERE kood=artikkel),(SELECT kmk_eesti FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) WHEN (@maa = 1) THEN isnull((SELECT KMkood_EU FROM artiklid WHERE kood=artikkel),(SELECT kmk_eu FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) END )) FROM in_tell_tellimused_read2 WHERE NUMBER=@webid --update tell_tellimused set saldo=(select sum(tkkm) from tell_tellimused_read where number=@number) where number=@number INSERT INTO #results VALUES (@kl_kood, 'Order', 0, 'CREATED','Orders',@NUMBER) UPDATE tell_tellimused_read SET tkkm=( rv_summa * (SELECT iif(ilmakm=0,0,((ilmakm) / 100)) FROM fin_kmkoodid WHERE kood=tell_tellimused_read.kmkood)) WHERE NUMBER=@NUMBER UPDATE tell_tellimused_read SET rsum=rv_summa + tkkm WHERE NUMBER=@NUMBER UPDATE tell_tellimused SET summa = (SELECT SUM(summa) FROM tell_tellimused_read WHERE NUMBER=@NUMBER), summakokku=(SELECT SUM(tkkm) + SUM(summa) FROM tell_tellimused_read WHERE NUMBER=@NUMBER), kmkokku=(SELECT SUM(tkkm) FROM tell_tellimused_read WHERE NUMBER=@NUMBER) WHERE NUMBER=@NUMBER END ELSE BEGIN INSERT INTO #results VALUES (@kl_kood, 'Order', 3, 'DUPLICATE','Orders',@kl_kood) END END ELSE BEGIN INSERT INTO #results VALUES (NULL, 'Item', 2, 'Incorrect AppKey','Orders',@webid) END SET @x=@x+1 FETCH NEXT FROM orders INTO @webid, @appkey_event END CLOSE orders DEALLOCATE orders DECLARE invoices cursor FOR SELECT CONVERT(nvarchar(MAX),NUMBER), appkey FROM in_mr_arved2 WHERE x=@KEY OPEN invoices FETCH NEXT FROM invoices INTO @webid, @appkey_event WHILE @@FETCH_STATUS = 0 BEGIN SET @kl_kood=@webid IF @appkey_event=@appkey BEGIN IF (SELECT COUNT(NUMBER) FROM mr_arved WHERE klienditellimus=@webid)=0 BEGIN EXEC dbo.get_dok_number @moodul='arve', @seeria='VEIKALIEMLV', @NUMBER = NULL, @cu='xmlcore', @aeg=@ag, @keel = 'default', @num =@NUMBER OUTPUT, @err = @err OUTPUT UPDATE mr_arved SET aeg=z.aeg ,aeg2=z.aeg2 ,Field5='0' ,klient_kood=z.klient_kood ,klient_nimi=z.klient_nimi ,klienditellimus=@webid ,lahetusaadress1=z.lahetusaadress1 ,lahetusaadress2=z.lahetusaadress2 ,lahetusaadress3=z.lahetusaadress3 ,lisa_field1=CASE WHEN (z.deal_type = '1') THEN N'Preču pārdošana' WHEN (z.deal_type = '2') THEN N'Pakalpojuma sniegšana' ELSE N'Preču piegāde' END ,lisa_field2=z.lisa_field2 ,lisa_field3=z.lisa_field3 ,lisa_field4=z.lisa_field4 ,lisa_field5=z.lisa_field5 ,lisa_field6=z.lisa_field6 ,tasuda=z.summakokku ,kokkumk=z.tasuda ,kaibemaks=z.kokkukmk ,kokku=z.tasuda ,kommentaar=z.kommentaar ,tyyp=z.deal_type FROM (SELECT * FROM in_mr_arved2 WHERE NUMBER=@webid)z WHERE mr_arved.number=@NUMBER SELECT @maa = isnull(maa,0) FROM kliendid WHERE kood=(SELECT klient_kood FROM mr_arved WHERE NUMBER=@NUMBER) INSERT mr_arved_read ( NUMBER ,rn ,rv ,artikkel ,seletus ,kogus ,yhik ,hind ,rsum ,tkkm ,konto ,kmk ) SELECT @NUMBER ,rn ,rn ,artikkel ,seletus ,kogus ,yhik ,hind ,rsum * kogus ,tkkm * kogus ,CASE WHEN (@maa = 0) THEN isnull((SELECT konto_myyk FROM artiklid WHERE kood=artikkel),(SELECT myyk_eestis FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) WHEN (@maa = 1) THEN isnull((SELECT konto_myyk_EU FROM artiklid WHERE kood=artikkel),(SELECT myyk_eu FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) END ,CASE WHEN (@maa = 0) THEN isnull((SELECT KMkood FROM artiklid WHERE kood=artikkel),(SELECT kmk_eesti FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) WHEN (@maa = 1) THEN isnull((SELECT KMkood_EU FROM artiklid WHERE kood=artikkel),(SELECT kmk_eu FROM artikliklassid WHERE kood=(SELECT klass FROM artiklid WHERE kood=artikkel))) END FROM in_mr_arved_read2 WHERE NUMBER=@webid --update tell_tellimused set saldo=(select sum(tkkm) from tell_tellimused_read where number=@number) where number=@number INSERT INTO #results VALUES (@kl_kood, 'INVOICE', 0, 'CREATED','INVOICES',@NUMBER) EXEC dbo.after_save_klient 'arve', @NUMBER, NULL, NULL, NULL END ELSE BEGIN INSERT INTO #results VALUES (@kl_kood, 'INVOICE', 3, 'DUPLICATE','INVOICES',@kl_kood) END END ELSE BEGIN INSERT INTO #results VALUES (NULL, 'INVOICE', 2, 'Incorrect AppKey','INVOICES',@webid) END SET @x=@x+1 FETCH NEXT FROM invoices INTO @webid, @appkey_event END CLOSE invoices DEALLOCATE invoices DECLARE sreceipts cursor FOR SELECT CONVERT(nvarchar(MAX),NUMBER), appkey FROM in_ladu_sissetulekud WHERE x=@KEY OPEN sreceipts FETCH NEXT FROM sreceipts INTO @webid, @appkey_event WHILE @@FETCH_STATUS = 0 BEGIN SET @kl_kood=@webid IF @appkey_event=@appkey BEGIN IF (SELECT COUNT(NUMBER) FROM ladu_sissetulekud WHERE hankija_arve=@webid)=0 BEGIN EXEC dbo.get_dok_number @moodul='sissetulek', @seeria='VEIKALIEMLV', @NUMBER = NULL, @cu='xmlcore', @aeg=@ag, @keel = 'default', @num =@NUMBER OUTPUT, @err = @err OUTPUT UPDATE ladu_sissetulekud SET aeg=z.aeg ,hankija_kood=z.hankija_kood ,hankija_nimi=z.hankija_nimi ,ladu=z.ladu ,sisekommentaar=z.sisekommentaar FROM (SELECT * FROM in_ladu_sissetulekud WHERE NUMBER=@webid)z WHERE ladu_sissetulekud.number=@NUMBER --select @maa = isnull(maa,0) from kliendid where kood=(select klient_kood from mr_arved where number=@number) INSERT ladu_sissetulekud_read ( NUMBER ,rn ,rv ,artikkel ,sisu ,kogus ,yhikuhind ) SELECT @NUMBER ,rn ,rn ,artikkel ,sisu ,kogus ,yhikuhind FROM in_ladu_sissetulekud_read WHERE NUMBER=@webid --update tell_tellimused set saldo=(select sum(tkkm) from tell_tellimused_read where number=@number) where number=@number INSERT INTO #results VALUES (@kl_kood, 'STOCK RECEIPT', 0, 'CREATED','STOCK RECEIPTS',@NUMBER) END ELSE BEGIN INSERT INTO #results VALUES (@kl_kood, 'STOCK RECEIPT', 3, 'DUPLICATE','STOCK RECEIPTS',@kl_kood) END END ELSE BEGIN INSERT INTO #results VALUES (NULL, 'STOCK RECEIPT', 2, 'Incorrect AppKey','STOCK RECEIPTS',@webid) END SET @x=@x+1 FETCH NEXT FROM sreceipts INTO @webid, @appkey_event END CLOSE sreceipts DEALLOCATE sreceipts SELECT @result1= (SELECT RESULT AS "@Type", descr AS "@Desc", NUMBER AS "@docid", ext_id AS "@ext_id", tyyp AS "@doctype", submittype AS "@submit" FROM #results FOR xml path ('Result')) SET @result2='<?xml version="1.0" encoding="UTF-8"?><results>'+CONVERT(nvarchar(MAX),@result1)+'</results>' SELECT @result1= (SELECT RESULT AS "@Type", descr AS "@Desc", NUMBER AS "@docid", ext_id AS "@ext_id", tyyp AS "@doctype", submittype AS "@submit" FROM #results FOR xml path ('Result')) SET @result2='<?xml version="1.0" encoding="UTF-8"?><results>'+CONVERT(nvarchar(MAX),@result1)+'</results>' SELECT @result2 DROP TABLE #results DROP TABLE #changes --cleanup --delete temp customers and put in log table INSERT log_in_kliendid2 SELECT * FROM in_kliendid2 WHERE x=@KEY DELETE FROM in_kliendid2 WHERE x=@KEY --delete temp items and put in log table INSERT log_in_artiklid2 SELECT * FROM in_artiklid2 WHERE x=@KEY DELETE FROM in_artiklid2 WHERE x=@KEY --delete temp items and put in log table INSERT log_in_tell_tellimused2 SELECT * FROM in_tell_tellimused2 WHERE x=@KEY INSERT log_in_tell_tellimused_read2 SELECT * FROM in_tell_tellimused_read2 WHERE NUMBER IN (SELECT NUMBER FROM in_tell_tellimused2 WHERE x=@KEY) DELETE FROM in_tell_tellimused_read2 WHERE NUMBER IN (SELECT NUMBER FROM in_tell_tellimused2 WHERE x=@KEY) DELETE FROM in_tell_tellimused2 WHERE x=@KEY --delete temp items and put in log table INSERT log_in_mr_arved2 SELECT * FROM in_mr_arved2 WHERE x=@KEY INSERT log_in_mr_arved_read2 SELECT * FROM in_mr_arved_read2 WHERE NUMBER IN (SELECT NUMBER FROM in_mr_arved2 WHERE x=@KEY) DELETE FROM in_mr_arved_read2 WHERE NUMBER IN (SELECT NUMBER FROM in_mr_arved2 WHERE x=@KEY) DELETE FROM in_mr_arved2 WHERE x=@KEY --delete temp items and put in log table INSERT log_in_ladu_sissetulekud SELECT * FROM in_ladu_sissetulekud WHERE x=@KEY INSERT log_in_ladu_sissetulekud_read SELECT * FROM in_ladu_sissetulekud_read WHERE NUMBER IN (SELECT NUMBER FROM in_ladu_sissetulekud WHERE x=@KEY) DELETE FROM in_ladu_sissetulekud_read WHERE NUMBER IN (SELECT NUMBER FROM in_ladu_sissetulekud WHERE x=@KEY) DELETE FROM in_ladu_sissetulekud WHERE x=@KEY --08.06.2020 range change from 2019 to veikaliemlv, version from 01.10.2019 --17.07.2020 corrections in orders, lahetusaadress3=z.lahetusaadress1 to lahetusaadress3=z.lahetusaadress3