Just to be the devils advocate...

1 - this is a local temp table. So only this connection is going to read from it which eliminates joining another active read...

Actually yes, forget SQL for 2 seconds and write the pseudo code with simple ifs.

I think your problem is that you can't express the business rule, not that you don't...

No, that's the solution I had to come up with.

Make an asp .net report project, compile to dll and only deploy the dll.

As for performance I think I get that...

want to see a really long query????

Just one last question. Are all those dashes (-) part of formatting for this message or is it part of the data?

Maybe something...

Look up charindex, left and substring in books online.

Luke L (12/21/2010)

---

There's no easy solution to this currently, other than to make certain the Admin doesn't have the ability to do this, but that could be a large undertaking...

Happy hunting ;-).

No need to.

What you need to do is make us understand what...

I was just joking. That's the price of the subscription for the article you cannot read.

But I...

That looks desperate.

I would go with let me work with you for free...

SELECT

Whatever

FROM

dbo.tbl

WHERE

1 = CASE WHEN Col LIKE '%your string here%' THEN 1

...

I seriously don't understand why you cannot simply do

SELECT * FROM Tbl

where [Region/trade] = 'EURO MED'

Then join to other tables if you're missing data.

Mike Dougherty-384281 (12/21/2010)

---

ronmoses (12/21/2010)

---

For educational purposes, I would genuinely appreciate it if one of the folks who take issue with the "most of the time" factor could illustrate a scenario...

Make sure you don't have linked server (or direct access) to excel files on the 32 bit. They won't work on the 64 bit server. There is apparently...

Sean Lange (12/21/2010)

---

Ninja's_RGR'us (12/21/2010)

---

Sean Lange (12/20/2010)

---

Ugh! Navision aka No Vision. Just went through a lengthy migration away from that product for one of our companies. Interesting that their licensing is...