Search split in split sqlserver

Question

DECLARE @keyword AS VARCHAR(MAX);
SET @keyword = 'cl613,zp300,4f001';

DECLARE @count INT;
SELECT @count = COUNT(value)
FROM STRING_SPLIT(@keyword, ',');
SELECT B.[Style],
       *
FROM [dbo].[tGRStyles] A
    LEFT JOIN
    (
        SELECT a.[Style]
        FROM
        (
            SELECT [Style],
                   [value]
            FROM [dbo].[tGRStyles]
                CROSS APPLY STRING_SPLIT([StyleCode], ',')
            WHERE value IN
                  (
                      SELECT value FROM STRING_SPLIT(@keyword, ',')
                  )
        ) a
        GROUP BY a.[Style]
        HAVING (COUNT([a].[Style]) = @count)
    ) B
        ON A.[Style] = [B].[Style]
WHERE B.[Style] IS NOT NULL;

Answer 1

SELECT *
FROM [dbo].[tGRStyles]
WHERE NOT EXISTS
(
    SELECT 0
    FROM STRING_SPLIT('PU501,HM404', ',')
    WHERE CHARINDEX(CONCAT(',', value, ','), CONCAT(',', StyleCode, ',')) = 0
);

Answer 2

lưu lại khi cần sử dụng