...see the article at the URL in my signature for how to get the best help.

"Must look eye"...

See anything wrong with the following?

from dbo.dwTreatment tvp join dbo.TreatmentVisit tv

on ...

You bet... let us know how things work out for you...

escaleraroyal (4/16/2008)

---

update.

Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that is causing the issue as...

Then, post the CREATE TABLE statement and some example data as outlined in the...

You life depends on this...

You need to answer a couple of questions...

1. Would you be happy with a non-dynamic SQL solution?

2. Are any TEXT, NTEXT, or IMAGE...

Nope... they would fall in the category of "abusers" or "Know-It-Alls"... heh... Know-It-Alls... funny how the abbreviation for that is "KIA"... 😛

If there is no difference between the DTS jobs, check both servers using the DBCC USEROPTIONS command... look for what the setting in the "dateformat" setting is. Compare the...

And, just a note... all the data should be stored vertically instead of horizontally... it should only be pivoted or cross-tabbed for display purposes... would make your calculations a whole...

Yeaup... that's the one I used. Works fine, fails safe, and drains to the bilge. 😉

GSquared (4/16/2008)

---

Jeff Moden (4/16/2008)

---

Thanks, Gus... the order was to preserve Asimov's original order and because they can be broken down more simply as "Protect the data, protect the project, protect...

Thanks, Gus... the order was to preserve Asimov's original order and because they can be broken down more simply as "Protect the data, protect the project, protect the user" and...

True enough... you won't always be able to use something like INNER MERGE JOIN because the optimizer doesn't always like it.

Teaching a man to fish... the WITH RECOMPILE option is...

Dang... I keep forgetting about that... thanks for the reminder, Matt. 🙂

Heh... you did it... you took the time to post some simple table structures and some data. You made my day because...