Arama:

--CARİYE GİTMEYEN TAHSİLAT ÖDEMELER
SELECT * FROM TAHODEME WHERE COUNTER NOT IN (SELECT FCOUNTER FROM CARI_HAR WHERE MODUL='TahOdeme')

--KASAYA GİTMEYEN TAHSİLAT ÖDEMELER
SELECT * FROM...

INSERT INTO STOK_BARKOD
(FIRMA_KODU,SUBE_KODU,STOK,BARKODNO,TIPI,BRBIRIM,BRKATSAYI)
SELECT 1,1,KODU,KODU ,'Serbest',BIRIM1,1 FROM STOK
WHERE KODU NOT IN (SELECT BARKODNO FROM STOK_BARKOD)
GO...

CREATE TRIGGER [dbo].[Tr_StokFiyat5Guncelle]
ON [dbo].[STOK_HAR]
AFTER INSERT
AS
BEGIN

DECLARE @CON INT
SET @CON = (SELECT COUNTER FROM INSERTED)

...