Gary Johnson (10/10/2008)

---

I would try this. Note that I'm only checking for existence in the case statement based on the left joins. I also removed your UDF in favor of...

Ok, try replacing the calls in the Query with just the definition. That should help some, anyway.

Those two UDF calls in the second subquery are probably killing any chance of optimizing it right now. Can you post their definition?

meichner (10/10/2008)

---

I have a Master/Detail relationship. My business rules state that there must be at least one Detail Item for each Master Item. From experience I know that...

You may need to move the corresponding SET NOCOUNT OFF to right...

This is a client code or VB6 error,...

Chris Morris (10/10/2008)

---

Hi chaps, this might sound a little blasphemous, but have you tried Visual Foxpro for importing the data? I worked with the product extensively in the 90's (MCP...

Plus, * is an XQuery wildcard.

I've seen it used for emoticons-> :Þ

That's my favorite cure! 😛

Glad we could help.

Well here's one hint: There is no computer program in the world that can take a grainy .1 megapixel bank camera photo and turn it into a stunning 20...

Here's another (simple) way to do it:

Select *

From Locations

Where NOT EXISTS( Select * From Excludes

Where Location LIKE '%'+Excludes+'%')

This is probably close to what Jeff intended to write, had...

Fernando (10/8/2008)

---

:w00t:

:exclamation:

Hello. This might something I am not familiar with in 2005. I have to restore a database in a test environment using a production backup. No big deal there....

You are going about this the hard way. You want to use "SUM( CASE ... )" constructs like this:

select employee_id,

employee_name,

SUM( CASE When billable = 'N' Then 1 Else 0...