CREATE PROC [dbo].[SP_URETICI_KODU_GUNCELLEME]
(@yeni VARCHAR(100), @stokKod varchar(100), @firmaKod varchar(100), @ureticiKod varchar(100))
AS
BEGIN
DECLARE @stokRef INT
DECLARE @firmaRef INT
SET @stokRef = ISNULL((SELECT REF FROM dbo.ITEMS WHERE CODE=@stokKod),0)
IF @stokRef<>0 AND @ureticiKod<>''
BEGIN
UPDATE IHR.dbo.PRODUCERCODES SET PRODUCERCODE=@yeni WHERE [PRODUCERCODE]=@ureticiKod AND STOCKREF=@stokRef 
END
END