WEll you need to check the indexes on your tables

Ok, have you checked your indexes and stats?

ranjita.damle (9/4/2008)

---

And how to do it when updating mailingname and mailingaddress fields in turn depends on entitytype of each row. so i need to traverse through it. Isnt it? Or...

OK cool,

I assume the query is slow at the processing level and not at the update level?

If so could post an execution plan please, else of the cursor version or...

could this not be done just using a select statement rather than a cursor?

Could you post you code please

Hi there,

Please could you give us the table structure and data in the table as well as your query.

Please refer to this link for tips how to get the best...

What do you want your results to be if there more than one row?

Do you want to process each row or just one?

If you just want to process one then...

HI there,

I try not to SET statements

but this allows you to do this.

SET QUOTED_IDENTIFIER OFF

SELECT " tester'tester "

Also you could look at this:

sp_executesql

HI,

Could you give us the code cause the problem please.

I'm also concerned that you say.

The query plans are almost the same and not the same!

Thanks

Chris

HI Again,

In that case could you give us the full tables and some sample data.

Thanks

Chris

Hi there,

Normally it's a good Idea to show us what you have tried so far and then we can guide you in the right direction.

Please refer to this ariticle for...

Sorry about my first post, I see you have already looked at the stats.

Is there anything different in the EXECUTION PLANS.

For Example a SCAN in test where there is a...

HEre is another solution

DECLARE @Sample TABLE

(

...

have you looked at the stats on that table in live?