Of course we won't know until the OP comes back. Looks like he isn't around SSC at the moment (14:56 MST).

And using your code with the condition flipped returns the first row and then fails. This now tells me that with the OR condition, it goes left to right.

select...

Depends on your interpretation of the requirements. MA is greater than M. :w00t:

You mean sorta like this:

select

*

from

sys.databases

where

name > 'M';

I built the temp table and ran the following queries:

select *

from #T

where isdate(col1) = 1

and datepart(year, col1) = 1

select *

from #T

where datepart(year, col1) = 1

and isdate(col1) = 1

Both failed for...

If SQL Server evaluated left to right, in the above query, it wouldn't have to evaluate the second condition if the...

Okay, but where do I look. I am most definately not a web developer (at the moment any way) and don't even know where to look on the server....

Not to hijack the thread for something totally unrelated, but....

Gail, according to your web site you've done web development at one time, so I have a very basic question for...

Glad to help.

Not having used CROSS APLLY myself, I'd have to say that it depends on what you are trying to accomplish.

By looking at your code, we really can't tell what the problem is. Your problem is also related to the data as apparently you are trying to insert data...

Jeff Moden (1/15/2009)

---

Okay, let's make it sore spots...

Not naming names which...

This is a double post. Please respond here

Please refrain from double posting. Most people that will try to help you monitor all the threads one way or another.

Michael Earl (1/15/2009)

---

Matt Miller (1/15/2009)

---

Steve Jones - Editor (1/15/2009)

---

Well it is steel, and likely move's fast in Gail's hands, but no, it's not a bike.

http://en.wikipedia.org/wiki/Katana

Got to play with sticks last...

Matt Miller (1/15/2009)

---

Steve Jones - Editor (1/15/2009)

---

Well it is steel, and likely move's fast in Gail's hands, but no, it's not a bike.

http://en.wikipedia.org/wiki/Katana

Got to play with sticks last night, Filipino...