In Sql How To Split An Select A String Which Is Not Present I A Table?

Here is my query I used to get UserID present in both where condition and TSTable SELECT UserID FROM TSTable WHER

Solution 1:

Is this what you're looking for?

select'IMS080'as UserID
  unionselect'IMS108'unionselect'IMS218';

Solution 2:

Try this

;WITH CTE AS 
(
    SELECT Split.a.value('.', 'VARCHAR(100)') AS USERID  
    FROM 
    (
        SELECTCAST ('<M>'+ REPLACE('IMS080,IMS108,IMS218', ',', '</M><M>') +'</M>'AS XML) AS Data  
    )AS A CROSS APPLY Data.nodes ('/M') AS Split(a)
)
SELECT*FROM CTE
WHERE USERID NOTIN (SELECT UserId FROM #TSTable)