CREATE PROC [dbo].[MALZEME_KAYIT_SIL]
(@KOD VARCHAR(100))
AS
BEGIN
DECLARE @ITEMID INT
DECLARE @COMPID INT
SET @ITEMID = ISNULL((SELECT REF FROM dbo.ITEMS WHERE CODE=@KOD), 0)
DELETE FROM dbo.ITEMS WHERE REF=@ITEMID
--DELETE FROM dbo.PRCLIST WHERE [ITEMREF]=@ITEMID
DELETE FROM [IHR].[dbo].[PRODUCERCODES] WHERE [STOCKREF]=@ITEMID
END