SELECT SUM(DATELENGTH(ColName)) As Bytes FROM dbo.table

I only see this error when the server is restarted or someone / something killed my connection.

sqlchanakya (12/21/2010)

---

Basically, in OLTP system, parallelism is not a good thing. The fact is that, the overhead on the parallelism and sometimes, one thread has to wait for the other...

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.