CREATE   PROCEDURE [dbo].[SP_UpdateProducerCodeAndCode_Param]
    @Code VARCHAR(MAX)
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE LG_011_ITEMS
    SET
        PRODUCERCODE = CASE
                          WHEN PRODUCERCODE IS NULL 
                               OR PRODUCERCODE = '' 
                          THEN CODE
                          ELSE PRODUCERCODE + '/' + CODE
                       END,
        CODE = EXPCTGNO
    WHERE CODE IN 
    (
        SELECT LTRIM(RTRIM(value))
        FROM STRING_SPLIT(@Code, ',')
        WHERE value <> ''
    );
END;