Sorry, misread the question.

GilaMonster (8/5/2011)

---

The Dixie Flatline (8/4/2011)

---

Just thinking out loud here. If he could come up with some sort of formula to condense the name strings down... by omitting...

Just thinking out loud here. If he could come up with some sort of formula to condense the name strings down... by omitting vowels for example... could...

I took Lowell's code and tossed in a couple of bells and whistles. Like standardizing the commas.

-- Dude, periods in state abbreviations... seriously?

SELECT CityState,City+', '+st as fixed,city,st

FROM

(SELECT...

A couple of comments:

1. Think of a view as a template of a query, with a lot of stuff pre-written for you (joins, columns, calculated columns). ...

Would you mind posting your solution up here?

Don't forget the warnings about performance....

Please post the execution plans.

One big difference is that, for the adhoc query, the optimizer knows absolutely that the value of @StartTime = '07/08/2011 19:00PM'. The...

A little snide and cynical is part of your charm, Gail. 😉

Shake it...

I have nothing to add except my compliments on a really good question.

Steve Jones - SSC Editor (7/27/2011)

---

The Dixie Flatline (7/27/2011)

---

Steve, maybe it's because I haven't had enough caffeine this morning, but I have a question: How does...

bopeavy (7/27/2011)

---

Thats great for the combinations but i do not know what they go to.

some select or what ever would show:

exid1 | exid2 | exid3 | combo

0 ...

Steve, maybe it's because I haven't had enough caffeine this morning, but I have a question: How does the ROWID column that you propose differ from...

Haven't seen Captain America yet, but I may see it twice this week.

Cap ties with Ben Grimm for my all-time favorite comic book hero.

That's true given the data supplied. But my understanding is that the requirement was to get the salary from the row with the max(id), whether or not...

Count this as another vote for opc.three's solution.

+1