I am confused. Why isn't robert's answer sufficient?

Jeff Moden (4/16/2008)

---

See anything wrong with the following?

from dbo.dwTreatment tvp join dbo.TreatmentVisit tv

on ...

Jeff Moden (4/16/2008)

---

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...

At a minimum you need to 1) script out the a_District table and 2) do as Ninja asked and add a "Print @cmd" to your p_trigger procedure right before the...

FYI: It is my understanding that as of SQL Server 2005, there is no longer any original SyBase code in SQL Server and that the licensing restrictions no longer...

You'll have to give us more information.

Here is a link that explains how: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Well, a derived table IS a subselect (as Gail pointed out to me once).

Anyway, i am just guessing since we do not really have enough information to complete this, but...

Why don't you want to do Backup/Restore? It is probably your best choice.

Its Wikipedia. People can post their opinions as facts anytime they want to.

It is however an absolute fact that Denormalization can, in some cases, dramatically improve performance and that...

Select GolferID, t2.CourseID

, t2.Hole1 - t1.Hole1

, t2.Hole2 - t1.Hole2

, t2.Hole3 - t1.Hole3

From Table2 t2

Join Table1 t1 ON (t1.CourseID-t2.CourseID)

Select SERVERPROPERTY('IsIntegratedSecurityOnly ')

This IS the difference...

Yes, data types NCHAR and NVARCHAR would allow you to store most any language. Sorting/collations are more complicated though.

Well, you can't really call it SQL "Injection" since they were actually trying to execute raw URL text as SQL. More like "SQL Suction".

select Col1 from Table1

EXCEPT

select Col1 from Table2