You mentioned that hardcoding string replacement wasn't an option... why is that? My first thought with something like this would be to make a lookup table of what to...

To clarify:

Are you looking for something to clean up all existing data that would run on a scheduled basis... or something that corrects the entries as they go into the...

Getting closer. The data you provided has 2 problems.

1. There is only 1 line. Whenever providing sample data, you should provide a minimum of 3-5 lines,...

Jack Corbett (11/18/2008)

---

Man, I hate it when someone else not only beats me with an answer, but has a better one 😉

Nice job Seth.

I wasn't going to complain about the...

Glad we could help. One other word of caution. You are selecting the Top 1 in that update clause, but you aren't ordering by anything. This could...

Paul, please keep questions on one issue in one thread in the future. The issue is still the aliasing. When you get that error in Query Analyzer or...

Heh, yeah, John is a bit tab happy. I usually use the prettifier to...

Right, and you need to alias the Select part of the query, as Chris keeps telling you =).

IF EXISTS(SELECT T1.ObjectID FROM @tmp_subjects t1

...

john.steinbeck (11/18/2008)

---

Ok, so it's top down... thanks for that...

I try to avoid Correlated Query's... That is why the previous Update Example I posted for this question is done... its used...

To specifically address the original question, so far as I've been able to tell, it's top down... with exceptions. Subqueries will NOT correlate. They will be evaluated pre-update...

Rogue Dead Guy Ale is actually my favorite beer... I almost said as much in the last post, but got busy and just submitted it. Two Hearted Ale is...

I have a feeling getting ahold of the Dr. Hexter's may prove difficult here in the states, but at least I know to snag them if I ever do come...

I try not to torture myself with thoughts of good beer during the day. That said, any particular bitters worth trying out? I'm a hophead myself, but most...

Actually, the answer was coffee. Keep practicing!

You can say it as many times as you want, it doesn't make any more sense with repetition ;). Please provide sample data and an example explaining what you...