CREATE PROC [dbo].[SP_MALZEME_ESLESTIRME]
    @stokKod VARCHAR(100)
AS
BEGIN
    SET NOCOUNT ON;

    /* Logo tarafinda stok bulunuyor mu? */
    DECLARE @lref INT =
        ISNULL(
            (SELECT LOGICALREF
             FROM [UNIVERSALDB].dbo.LG_011_ITEMS
             WHERE CODE = @stokKod),
        0);

    /* Eger 0 ise — stok yok — prosedürden çik */
    IF @lref = 0
        RETURN;     -- baska islem yok

    /* IHR tarafinda ayni LOGICALREF var mi? */
    DECLARE @rref INT =
        (SELECT [REF] FROM IHR.dbo.ITEMS WHERE LOGICALREF = @lref);

    IF @rref IS NOT NULL
    BEGIN
        -- LOGICALREF zaten var; birlestir
        EXEC dbo.MALZEME_BIRLESTIR @rref, @stokKod;
		-- Yoksa, mevcut stok koduna LOGICALREF'i bas
        UPDATE IHR.dbo.ITEMS
        SET LOGICALREF = @lref
        WHERE [CODE] = @stokKod;
    END
    ELSE
    BEGIN
        -- Yoksa, mevcut stok koduna LOGICALREF'i bas
        UPDATE IHR.dbo.ITEMS
        SET LOGICALREF = @lref
        WHERE [CODE] = @stokKod;
    END
END;