Guiness is OK, still not as good as a real ale. Corona? Blech! The best beer out of Ol Mehico is Bohemia. Great stuff. Hold the friggin' lime.

Actually, I haddn't thought of that, but yeah, in most cases this is probably quicker.

Ooh, Steve, if you're taking orders, grab a keg of something... how about Ruddles County. If not that, use your judgement.

I'm jealous Steve. English beer... Mmmmmm! A few pints of real ale and I'll hug everybody.

Looks like the SuppContacts table has one row for email with phone null & one row for phone with email null? Better design would probably be to seperate these into...

CTE's are only available for the next SELECT statement. You can't define a CTE & then run multiple selects against it. If you need that kind of functionality, you'll need...

I tried setting up the two tables and putting together some sample data, but I can't run your query. As I suspected it returns more than one row in the...

Holy Cow! Discussions around the proper placement of the f-bomb in sentence structure in order to communicate with the squids is serious? I clearly need to get out more.

<hug>

I'll be...

It looks like the correlatted query can return more than one value and that will cause the query to fail.

Here's a first pass substitute:

SELECT ItemNo_,ItemDescription, COALESECE(a.Description,b.Description)

FROM Item

JOIN ItemExtraDescription a

ON Item.No_=a.No_

AND...

I believe that debugging is only available through Visual Studio.

http://msdn2.microsoft.com/en-us/library/ms165034(VS.80).aspx

Quick and dirty, completely inelegant and unefficient and you might have to run it two or three times in a row, but it will do the job.