Hi,

You can write like this:

If(your condition)

SET @result=1

ELSE

SET @result=0

OR

IF(your condition)

SELECT @result=1

ELSE

SELECT @result=0

Eugene,

I have applied necessary changes in query.

If I removed below code from sql query then query executed in 2 seconds.

,str_SourceID=STUFF(( SELECT ','+ str_SourceOfData FROM tbl_MARC_MemberSourceData MSD,tbl_MARC_SourceMaster SM

WHERE MSD.fk_MemberId =...

Hi,

Index temp tables and table variable are stored in tempdb.

Less resources required for table variable as compared to index temp tables. that's it.

Hi,

I know table variable allocating less resources as compared to index temp tables and also it stored in temp db.

But how to improve below query. it's taking more than one...

Hi,

1: #test table will allocate resources and it's stored in tempdb.

2: You can alter variable at runtime to #test and also create Clustered and other indexes as well.

3: Use table...

Hi,

1: #test table will allocate resources and it's stored in tempdb.

2: You can alter variable at runtime to #test and also create Clustered and other indexes as well.

3: Use table...

Hi,

Thanks for reply but some problems are

#2: Indexed temp table allocating resources in temp db as compared to table variable.

#4 & 5: TOP 1 used two times because one member...

Hi,

Why you are using cursors? it's degrade the performance of sql query and also consuming memory..

Use while loop instead of cursor. You can see the dramatic performance... In while loop...