Gail,

I tried with 'DYNAMIC SQL'. But the ecexution time still remain same.

Declare @ID varchar(255), @AssetType_Code INT,@SQL varchar(255),@WHERE varchar(255)

Select @ID = ''

--select @AssetType_Code = isnull(@AssetType_Code,'')

SELECT @sql = 'Declare @ID varchar(255) Select...

Declare @ID varchar(255), @AssetType_Code INT

Select @ID = ''

--select @AssetType_Code = @AssetType_Code

SELECT @ID = @ID + ',' + CAST (ID AS VARCHAR(3))

FROM tblStrategy_k

WHERE Strategy = 'A3_fund' --UPPER(@StrategyName)

--AND (AssetType_Code = @AssetType_Code...

Declare @ID varchar(255), @AssetType_Code INT

Select @ID = ''

--select @AssetType_Code = isnull(@AssetType_Code,'')

SELECT @ID = @ID + ',' + CAST (ID AS VARCHAR(3))

FROM tblStrategy_K

WHERE Strategy = 'A3_Fund' --UPPER(@StrategyName)

--AND isnull(AssetType_Code,'') = @AssetType_Code

AND...

you mean UPPER() function ?

Query without CURSOR ( SET BASED )

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:

...

elutin,

I am not getting your point.

you mean to say that using UDF is ok.

what do you mean by in-line SQL ?

i just little bit confused...what is the difference between...

http://scarydba.wordpress.com/2008/07/01/constant-scan-in-execution-plans/

Pls find the attached query plan.

ColdCoffee....I too observed the result. Yes...You are correct! Second one will display 2 more result.

No...No...Curently the procedure is using LOOP to split the delimited values. I have to replace it with the above...

any other way ?

elutin (5/20/2010)

---

Have you aware had the division by zero error in the code like that:

SELECT A/B FROM TABLE1 WHERE B!=0

No? Welcome to Microsoft SQL Server version 2005 and higher query...

Welcome to Microsoft SQL Server version 2005 and higher query optimiser.

IT MAY HAPPEN! As optimiser may deside to evaluate devision result before applying WHERE filter (or JOIN) and return the...

I tried with 'Tally' table...

DECLARE @phrase VARCHAR(200);

SET @phrase = ',' + 'book,paper,computer' +',';

SELECT word, word_order ,'%,' + word + ',%'

FROM (SELECT SUBSTRING(@phrase, n,...

ColdCoffee (5/18/2010)

---

You probably wil have to use Paul White NZ's N-Way Handshaking code for your requirement!

NOTE : Jeff Moden had advised that this code contains triangular joins and we...

post the DDL with some sample data. I am sure you can get HELP from here.