Database

<br />
<br />
'Gonna use FSO - need a reference to Windows Script Host object model<br />
Dim FSO as new FileSystemObject<br />
<br />
<br />
'Close any connections to the DB to ensure no access rights probs<br />
Conn.Close()<br />
<br />
'Use the FSO to copy the file<br />
FSO.CopyFile SrcMDB, DestMDB, bOverwrite<br />
<br />

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