Thanks Adi

/*

I am not telling this is the best way but hope this can help u

*/

create table #table

(

Description varchar(max)

)

insert into #table (Description) values('Speed');

insert into #table (Description) values('jhg j jg jgkjhg jh...

1. make i/p parameter as string like:

@input = ',speed,fuelEfficient,sportsUtility'

Now Search like this:

SELECT * FROM #temp

WHERE

',' +@input + ','LIKE '%,' + Description + ',%'

---Below command will solve ur problem

BACKUP LOG WITH TRUNCATE_ONLY

GO

DBCC SHRINKFILE ()

Following statement tells about details of db file:

SP_HELPFILE

/*

This example will clear your doubts.

*/

---Creating tables

CREATE TABLE tbl1

(

IdINT,

FNameVARCHAR(1)

)

CREATE TABLE tbl2

(

IdINT,

FNameVARCHAR(1)

)

--Insert records to table

INSERT INTO tbl1

VALUES(1,'A')

INSERT INTO tbl1

VALUES(2,'B')

INSERT INTO tbl1

VALUES(3,'C')

INSERT INTO tbl1

VALUES(4,'D')

INSERT INTO tbl2

VALUES(1,'A')

INSERT INTO tbl2

VALUES(2,'B')

--Inner join will return...

If u want all the records from table 1 whether it does match or doesn't match with table2, Then u consider left outer join or right outer join. But...

you can get information related with table usage from this : sys.dm_db_index_usage_stats

I think following will be helpful for u :

SELECT

part1.a,part1.b,part2.d

FROM

(

SELECT tbl1.a, tbl2.b

FROM tbl1

INNER JOIN tbl2

ON tbl1.c = tbl2.c

) part1

INNER JOIN

(

SELECT tbl1.a, tbl3.d

FROM tbl3

INNER JOIN tbl1

ON tbl1.c = tbl3.c

) part2

ON...

Thanks for reply....

I am converting a package from DTS to SSIS and there

in SSIS Package I need to have a equivalent functionality for the dynamic property task that...

First Question is for SSIS

Second question is for DTS

Thanks for ur reply... As U mentioned use Nvarchar(MAx), But when I Add a variable, there is option for string and Char , then I Press 'F4' and go to...

Thanks... I applied the same thing suggested by u and it is working.

Thanks, for your reply. But here I would like to know that how can I assign the result of an Execute SQL Task to a variable.

...