CREATE   PROCEDURE dbo.Update_ClCard_Specodes
(
    @Codes NVARCHAR(MAX),     -- 'MUSTERI001,MUSTERI002,MUSTERI003'
    @Specode2 NVARCHAR(MAX),  -- 'A1,A2,A3'
    @Specode3 NVARCHAR(MAX)   -- 'B1,B2,B3'
)
AS
BEGIN
    SET NOCOUNT ON;

    ;WITH Codes AS (
        SELECT Position, Item AS CODE
        FROM dbo.SplitString(@Codes, ':')
    ),
    S2 AS (
        SELECT Position, Item AS SPECODE2
        FROM dbo.SplitString(@Specode2, ':')
    ),
    S3 AS (
        SELECT Position, Item AS SPECODE3
        FROM dbo.SplitString(@Specode3, ':')
    ),
    Merged AS (
        SELECT c.CODE, s2.SPECODE2, s3.SPECODE3
        FROM Codes c
        JOIN S2 s2 ON c.Position = s2.Position
        JOIN S3 s3 ON c.Position = s3.Position
    )
    UPDATE C
    SET 
        C.SPECODE2 = M.SPECODE2,
        C.SPECODE3 = M.SPECODE3
    FROM UNIVERSALDB.dbo.LG_011_CLCARD C
    INNER JOIN Merged M ON C.CODE = M.CODE;
END