Code gốc 

SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');

In a practice run, the preceding SELECT returned following result table:

value
Lorem
ipsum
dolor
sit
amet.


Sử dụng

SELECT r.ID,r.RegCode,r.Approval,r.LocalType,r.StatusDeposit,r.DepositDate,r.ObjID,r.InputType,r.StatusReg,r.RegType FROM  Internet.dbo.RegistrationFTS (NOLOCK) AS r
            WHERE 1=1                
                AND r.ID IN (SELECT value FROM STRING_SPLIT(',1091175913,1091175983,1091176013,', ','))


Code gây chậm 

SELECT r.ID,r.RegCode,r.Approval,r.LocalType,r.StatusDeposit,r.DepositDate,r.ObjID,r.InputType,r.StatusReg,r.RegType FROM  Internet.dbo.RegistrationFTS (NOLOCK) AS r
            WHERE 1=1                
                AND charindex(',' + CAST(r.ID as nvarchar(20)) + ',', @pRegIDStagList) > 0