Clever question. Thanks!

Luis Cazares (2/11/2014)

Gary Varga (2/11/2014)

Craig-315134 (2/11/2014)

Gary Varga (2/11/2014)

Oh, I wish I found that to be the...

Lowell,

This is brilliant. Thanks very much for putting this together and for passing it along. This saves me a lot of work today and in the future.

Thanks,

Are you saying you don't have any...

D'oh! Luis' explanation is very likely correct. Even if it's not, it's...

That's odd. Can you confirm whether the sample data I used above is correct for your situation? Because if it is, then I have no idea why you...

Would something along these lines do the trick for you? It seems to match the desired output given in your original post.

select distinct [company name] from CompanyInfo as A

where

[Company...

Hello and welcome to the forums.

It's considered best practice around here to post sample data and table structure as DDL when asking questions. This helps other people get right...

Gillian,

Bit of advice. Whenever you're building an UPDATE...

Scott-

Would it be better to do it like this:

UPDATE T

SET order_class = 'MTO'

FROM #Table T

join #Table T2 ON t.custNo = T2.custNo and

t2.order_class = 'MTO' and

t.order_class != 'MTO'

or...

Neither. You should be able to accomplish this with a single UPDATE statement.

You can either use a sub SELECT in the WHERE clause, or a self join to filter...

In your test data, should "('(Location is Europe')" read "('Location is Europe')"? or is that left-parenthesis actually in your data?

I don't think you can make ON clauses conditional. Try replacing your inner join with 2 seperate LEFT OUTER JOINs to Table2.

Then use ISNULL() in your...

What have you tried?

Do you mean something like this:

SELECT CASE NodeAlias WHEN '101.101.101.101' THEN 'UniqueName' ELSE 'Larry' END

FROM MyTable

or

SELECT NodeAlias + ' - ' + CASE NodeAlias WHEN '101.101.101.101' THEN 'UniqueName' ELSE...