DECLARE @Codes TABLE(Code NVARCHAR(50));
INSERT INTO @Codes
VALUES(N'699962167387'),(N'604963100353'),(N'604963100387'),(N'604963100388'),(N'604963100391');
DECLARE @Codes2 NVARCHAR(MAX) = N'60496310010,60495770390,60492500391';
INSERT @Codes(Code)
SELECT * FROM STRING_SPLIT(@Codes2, ',') s WHERE LTRIM(RTRIM(s.value)) <> ''
SELECT * FROM Accounting.SanadLanguage sl WITH(NOLOCK)
WHERE EXISTS (SELECT 1 FROM @Codes c WHERE sl.Tozihat LIKE N'%'+c.Code+'%');
SELECT * FROM Accounting.SanadLanguage a WITH(NOLOCK)
JOIN @Codes b ON a.Tozihat LIKE N'%'+b.Code+'%'
توجه: چون این جدول خیلی طولانیست، ادامه مطلب بروید.
ادامه نوشتهhttps://drive.google.com/drive/folders/1lHN6kzNKZYmeOp0Q_1FnT5nz1HTkqy6_?usp=sharing