Database

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.

Mohammad Daba`an wrote:

May you explain me the flag you wrote? or what do u mean by a flag?

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Rule]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rule]
GO

CREATE TABLE [dbo].[Rule] (
	[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
	[Name] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
	[Solution] [int] NULL ,
        [Deleted] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO