CREATE PROC [dbo].[SP_URETICI_KODU_EKLE]
(@yeni VARCHAR(100), @stokKod varchar(100), @firmaKod varchar(100), @tur SMALLINT)
AS
BEGIN
DECLARE @stokRef INT
DECLARE @firmaRef INT
SET @firmaRef = ISNULL((SELECT REF FROM dbo.COMPANIES WHERE DEFINITION_=@firmaKod),0)
SET @stokRef = ISNULL((SELECT REF FROM dbo.ITEMS WHERE CODE=@stokKod),0)
INSERT INTO [IHR].[dbo].[PRODUCERCODES] (STOCKREF,CLIENTREF,[PRODUCERCODE],[STS]) VALUES (@stokRef,@firmaRef,@yeni,@tur)
END