Database

SELECT *
FROM tblUsers
WHERE UserID IN (SELECT [Value] FROM dbo.Split(<code>@ListOfUserIDs</code>,','))

CREATE FUNCTION dbo.Split
(
	@List nvarchar(2000),
	@SplitOn nvarchar(5)
)  
RETURNS @RtnValue table 
(
		
	Id int identity(1,1),
	Value nvarchar(100)
) 
AS  
BEGIN

	WHILE (CHARINDEX(@SplitOn,@List)>0)
	BEGIN 
	
	INSERT INTO @RtnValue (value)
	SELECT 
	    Value = LTRIM(RTRIM(SUBSTRING(@List,1,CHARINDEX(@SplitOn,@List)-1))) 
	
	   Set @List = SUBSTRING(@List,CHARINDEX(@SplitOn,@List)+LEN(@SplitOn),LEN(@List))
	END
	
	INSERT INTO @RtnValue (Value)
	SELECT Value = LTRIM(RTRIM(@List))
	
	RETURN
END

DECLARE SqlStr varchar(1000)

SET SqlStr = 'SELECT * FROM tblUser WHERE UserID IN (' + @ListOfUserID + ')'
EXEC (SqlStr)

SELECT x.Desc, case when y.ID is null then 'False' else 'True' end as There
FROM X
LEFT OUTER JOIN Y ON Y.ID = X.ID
WHERE Y.Person = 856

SELECT distinct c.GeneralDescription,
case when l.UsageId is null then 'False' else 'True' end as There
FROM tUConsumer c
  LEFT OUTER JOIN tLuUsage l ON c.CMCode = l.UsageIndex
  INNER JOIN tTesterUsage t ON l.UsageId = t.UsageId
where t.TesterId = @TesterId

--Create temp table containing all possible descriptions.<br />
select distinct Desc<br />
   into #temp01<br />
   from YourTable<br />
<br />
--Use outer join to pull list of all descriptions, then cross-match<br />
--with person attributes.  If the person does not have a matching<br />
--attribute then the YT.Desc value will be null.  The "case" <br />
--statement outputs true/false appropriately.<br />
select T1.Desc,<br />
      case when YT.Desc is null then 'True' else false end There<br />
   from #temp01 T1<br />
   left outer join YourTable YT<br />
      on YT.PersonId = 856<br />
      and YT.Desc = T1.Desc<br />
   order by 1