Here're are some suggestions to get you started - based on the info you've given:

1) Start from the very top - meaning - if you're dealing with 2 healthcare teams...

Mathew...you could do something like this:

select Result = case

when Text1 = '*' then (Num1...

Sergiy - not sure if you've accidentally posted the response to some other post over here ?!?!

& then there's Lowell's... "XML is like violence...If it doesn't solve your problem, you are not using enough of it."

Yuri - to check for even/odd # of rows, you could use this logic..

if (select (count(*) % 2) from myTable) = 0

print 'even'

else

print 'odd'

here's another one along the same lines...

little boy crying - "mom, mom - I don't want to go to America"

sound of a stinging slap followed by mom's voice - "shut...

"who'd have thunk" gpf^192 that you were such a romantic!!!

nothing to do with the bard, but with the folly of many women...

If you want...

a couple of suggestions:

is a log file being generated that you could perhaps take a look at to see if there's any more information?!

here's something from microsoft for similar errors...

thx. homebrew01 - however I too think the deferred names are only for stored procedures...have to "play around" with this sometime to get...

sorry - no clues for I'd just give the quote away...I have a peace offering instead...I said earlier didn't I - DON'T SHOOT!

A...

If you're asking me Lee - nope! About lawyers - s..m de la s..m - I would post anything at all without thinking twice...

sswords...

I'm almost afraid to confess that I'm still guffawing over what Lee posted..I have a great Shakespeare quote that were I the person who could be gutsy enough to be...

Have you tried increasing the "query time" in your odbc configuration to see if this fixes it ?!

My all-time favourite & one that I (unfortunately) live by...

"The only way to get rid of a temptation is to yield to it." - oscar wilde

***sswords - not starting a new thread but thought this is a good time to reinstate an old classic***

You see a poster on a truck with IAMS and you think...