CREATE PROC [dbo].[SIPARIS_KONTROL]
(@FISNO VARCHAR(100))
AS
BEGIN
DECLARE @FISID INT
DECLARE @KONTROL INT
SET @FISID = ISNULL((SELECT REF FROM dbo.FICHES WHERE FICHENO=@FISNO), 0)
SET @KONTROL = ISNULL((SELECT COUNT(*) FROM dbo.FICHE_LINES WHERE FICHEREF=@FISID),0)
IF @KONTROL = 0
BEGIN
DELETE FROM dbo.FICHES WHERE REF=@FISID
END
END