How your peoples are saying it will give different result ?

For example

Table A Table B

1 ...

I agreed all your experts answer. But in memory level where worktable will be stored ?

For example if i create # table then it will be stored in TempDatabase.

But if...

Any output ?

If we take any performance related article or document, definetely it highlight the below point ' don't use distinct keyword in your query.It decrease your performance'.

Thats why i posted this...

No No this is not an interview question.....

How to replace this <> operator in or sql query ?

But i dont want to use the below logic.

for example

select columnname from table name where salary <> 0

Alternate way...

Answer pls....

so do we need to use the same structure for both the cursors ?

Stucture :

Declare cursor

Open cursor

fetch

close cursor

Deallocate cursor

am i correct ?

URL : http://msdn2.microsoft.com/en-us/library/aa215533(SQL.80).aspx

if you see the sqlserver6.X side from the table , you can see the below sentence

'Several system stored procedures were used for documenting keys'.

I am talking about documenting...

Just Update the Null columns as blank values

Update yourtablename

set add1 = ''

where add1 is null

Now execute your code, it should work

do You know why are you getting 'NULL' Values ?;)

Experts ! Kindly clarify my doubts

Thanks Vaidiyanathan.

I dont know dynamic index will only help to resolve the issue. do note down the

statistitics io & statistics time and check out the query plan too.

ken,

Can you just explain me the N.N part alone ?

Regards

Karthik

Sorry Ken ! your code is satisfying my need. Thanks a lot.

I am unable to understand your logic.Can you please explain me the logic ?

Regards

Karthik