CREATE PROCEDURE [dbo].[sp_UpdateOrInsertSiparisVer]
    @stockRef VARCHAR(300),
    @userId INT,
    @amount VARCHAR(50)
AS
BEGIN
		DECLARE @logref INT
		SET @logref = ISNULL((SELECT LOGICALREF FROM LG_011_ITEMS WHERE CONCAT([NAME], [NAME3])=@stockRef),0)
        INSERT INTO STOK_RAPOR_SIPARISLER (STOCKREF, USERID, AMOUNT, TYPE_, ORDERDATE)
        VALUES (@logref, @userId, @amount, 1, CAST(GETDATE() AS DATE));
		INSERT INTO STOK_RAPOR_SIPARISLER_LOG (STOCKREF, USERID, AMOUNT, TYPE_)
        VALUES (@logref, @userId, @amount, 2);
END;