Düzenle: SP_LISTE_FIYAT_KULLANIM_DISI_TOPLU

İlgili Uygulama

Nesne Türü

Nesne Adı

Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)

Genel Kullanım Amacı ve Notlar

Tam SQL Kodu

CREATE PROC [dbo].[SP_LISTE_FIYAT_KULLANIM_DISI_TOPLU](@KOD VARCHAR(5000))
AS
BEGIN
    -- Split the input @KOD into a table of codes
    DECLARE @CodeTable TABLE (Code VARCHAR(100))
    DECLARE @pos INT
    DECLARE @code VARCHAR(100)
    
    -- Remove special characters and trim spaces
    SET @KOD = REPLACE(@KOD, CHAR(13), '')  -- Remove carriage returns
    SET @KOD = REPLACE(@KOD, CHAR(10), '')  -- Remove line feeds
    SET @KOD = REPLACE(@KOD, CHAR(9), '')   -- Remove tabs
    SET @KOD = REPLACE(@KOD, ' ', '')       -- Remove spaces

-- Add a comma at the end to get the last code
    SET @KOD = @KOD + ','  
    SET @pos = CHARINDEX(',', @KOD)
    WHILE @pos > 0
    BEGIN
        SET @code = LTRIM(RTRIM(LEFT(@KOD, @pos - 1)))
        IF LEN(@code) > 0
        BEGIN
            INSERT INTO @CodeTable (Code) VALUES (@code)
        END
        SET @KOD = RIGHT(@KOD, LEN(@KOD) - @pos)
        SET @pos = CHARINDEX(',', @KOD)
    END

-- Update LG_011_ITEMS table
    UPDATE LG_011_ITEMS
    SET ACTIVE = 1
    WHERE LOGICALREF IN (SELECT LOGICALREF FROM LG_011_ITEMS WHERE CODE IN (SELECT Code FROM @CodeTable))
    
    -- Update LG_011_PRCLIST table
    UPDATE LG_011_PRCLIST
    SET ACTIVE = 1
    WHERE CARDREF IN (SELECT LOGICALREF FROM LG_011_ITEMS WHERE CODE IN (SELECT Code FROM @CodeTable))
      AND PTYPE = 2
END

Oluşturulma: 23.12.2025 07:15 Son Güncelleme: 23.12.2025 17:28

İptal Nesneyi Sil