CREATE COMMA SEPERATED LIST OF VALUES TO SEARCH BY CHARINDEX

---CREATE COMMA SEPERATED LIST OF VALUES TO SEARCH BY CHARINDEX

DECLARE @CSVIDs varchar(max)
SELECT DISTINCT @CSVIDs = STUFF((SELECT DISTINCT text_id /*EntityNames*/ +',' FROM #c FOR XML PATH ('')) ,1,0,'') -- (xwaid)

--USAGE OF CSV STUFFED
IF (object_id('tempdb..#SearchResultList') is not null) DROP TABLE#SearchResultList;

SELECT DISTINCT en.ID, en.OPID, en.EntityNames, en.WAID
 INTO #SearchResultList
from myDatabase.dbo.EntityNames en
where
 charindex(ce.OPID,@CSVIDs) > 0