Database

Uma Kameswari wrote:

Yes we can put a select statement inside the IN expression but if the column contains a list of values separated by comma(,) then...

Apurva Kaushal wrote:

Actually what she has given was some values in a variable thats why I had given that type of solution

declare @list nvarchar(1000)
set @list = select words from sample
select * from emp where dept in(@list)

Apurva Kaushal wrote:

yep and there exactly I got confused and gave that solution.

Colin Angus Mackay wrote:

You sometimes need to read something like that a couple of times to really understand what is wanted.

SELECT * 
FROM Table1
WHERE SomeColumn IN (SELECT Something FROM Table2)

<br />
CREATE FUNCTION [dbo].[function_string_to_table]<br />
(<br />
	@string VARCHAR(MAX),<br />
	@delimiter CHAR(1)<br />
)<br />
RETURNS @output TABLE(<br />
	data VARCHAR(256)<br />
)<br />
BEGIN<br />
<br />
	DECLARE @start INT, @end INT<br />
	SELECT @start = 1, @end = CHARINDEX(@delimiter, @string)<br />
<br />
	WHILE @start < LEN(@string) BEGIN<br />
		IF @end = 0 <br />
			SET @end = LEN(@string) + 1<br />
<br />
		INSERT INTO @output (data) VALUES (SUBSTRING(@string, @start, @end - @start))<br />
		SET @start = @end + 1<br />
		SET @end = CHARINDEX(@delimiter, @string, @start)<br />
	END<br />
<br />
	RETURN<br />
<br />
END<br />
<br />

<br />
DECLARE @values VARCHAR(MAX)<br />
SELECT @values = col1 FROM table2 WHERE FOO = 'BAR'<br />
<br />
SELECT * FROM table1 <br />
WHERE col1 IN (<br />
  SELECT data FROM dbo.function_string_to_table(@values, ',')<br />
)<br />
<br />

Bartosz Bien wrote:

I tried MSDE, but it required dozens of seconds for the preload operation, while the same information loaded from a custom-format binary file loads in approx. 2 seconds.