However, the Developers Edition is actually the Enterprise Edition with different licensing. Therefore all the features of the Enterprise Edition are available in the Developer Edition.

To be sure, not completely sure. I normally don't provide support for the front-end application. I usually keep to the SQL side of things and let those who...

PW (1/15/2009)

---

I'll take a break from gnashing my teeth & swearing at the original coder to add my common mistake:

Frequent use of DISTINCT to hide a fundamental design flaw and/or...

noeld (1/15/2009)

---

For some reason I think this...

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