Heh... it would appear so... maybe this one would make a good article. Thanks, Barry.

Um... heh... no, sorry... pointing someone to a Cursor Usage URL is not what I'd call a "good start" even if it has a better answer in the post that...

For the type of queries...

You don't understand... it IS the problem because it causes @sql to be truncated as if IT were an NVARCHAR.

There are certain times where you can get away without using the table hint to force the index. I've done it in certain functions using table variables. You...

:blush: Thanks, John.

jsteinbeck (10/31/2008)

---

I read somewhere (i think it was AskTom) but depending on how you wanted your data or the business logic (the way you write your query if using a...

Heh... the problem with the indecision that some face as to who to vote for is simple... which idiot will cause the least amount of damage? 😛

If you want...

There's virtually no difference between a JOIN and an IN (subquery)... they will both create the same execution plan and execute within milliseconds of each other... unless there's a correlation...

Heh... yeah... I forgot to add that on... 😛 So many cars... so little wax. :hehe:

Muralidharan Venkatraman (10/31/2008)

---

:(I have a production application which holds 100+ tables which does not have primary keys at all and running in sql server 2005. I inherited this application and...

Nicely done! And thanks for the feedback especially on the performance/durations.

My only concern is the BEGIN/COMMITs you have for Stages 1 through 4... the [CPMTEST].[XJASN4N].[tblCLS_OFSA] is a...

ry.rith (10/31/2008)

---

Thank so much,

that you tell me about the solution.

I also do the same of yours to complete the crosstab-report, but something that i want is to know why it's...

Heh... I've just gotta agree with that! 😛

If you do it this time, you'll actually get a tested answer... 😉