Heh. That's a neat bit of amphibology. 😀

Is A.Account_Number an NVarchar()? If so then you should CAST C.Customer_ID to NVarchar() in your ON clause.

Why are you using "not in" here instead of "<>" or "!="?

mtassin (11/11/2008)

---

Just curious because we're looking at moving about 4,000 databases currently split between two instances in a clustered environment (4 active nodes) to 4 instances in a clustered environment...

It is not at all clear what you are trying to do. In particular, this:

They are both the same except that the table variable has only 1 row for...

SQL DBA 808 (11/11/2008)

---

I should add that there is no way to link the records that come after the Header record except that they are the records between each record...

Adam Hardy (11/11/2008)

---

I've got one stored proc which opens a transaction then does an update (which fires a trigger). The weird thing is the @@TRANCOUNT when printed from within the...

Here is an article by some smart guy that explains how to do this: http://www.sqlservercentral.com/articles/Test+Data/61572/

dglane (11/11/2008)

---

I had found that article too but I would really love to find your comment (i.e. "Some RDBMS vendors, like Oracle but not SQL Server, implement a NATURAL JOIN...

Probably like this:

SELECT DISTINCT (

SELECT COUNT (Lesson_CatId)

FROM Session_Information, Lesson_DateSchedule

WHERE Lesson_CatId = "001" OR Lesson_CatId ="003" OR Lesson_CatId = "004" OR Lesson_CatId = "005"

...

Toad has a Query Optimizer? Huh, I didn't know that...

I cannot help you much here,...

That's Great! Glad it worked out and thanks for the feedback.

On the other hand, if two or more different people logged-on to my DE SQL Server, that would be a violation of the license. This is true, even if...

I believe that the "One User" restriction is a license restriction, but is not implemented as a software restriction. In other words, you are constrained by the legal agreement...