Mmmm.... pork chOPS. 😛

Do you really think you should get the job if you don't have the skills they want?

Are you going to talk to the interviewer and say:

"I was able...

Limited precognition is actually one of my mutant powers, Gail. Having looked at that thread I had...

Nope that would only add excitement to baseball if you were allowed to clock the 1st baseman in the ribs to make him drop the ball as he was catching...

At least in cricket, you take the bat with you when you run. Something I think would add a lot of much-needed excitement to baseball. ...

That is an impressive number of views. I always felt that The Thread is a large part of what makes SSC seem more like a community, rather...

Gaaaahhhh.... I get really focused on my real life and work for a couple of days and I miss all the excitement. :w00t:

I'm glad I...

Two ways off the top of my head.

1. GROUP BY with ROLLUP

2. Put your results in a temp table (or make it a cte) and then SELECT *...

Two-step it:

1. Write query to pull every customer that bought a bike, do it as a cte or store results in a temp table.

2. Join the cte...

Come on along and have a Dr. Pepper, Lynn.

What's an index?

Paul, we need to go have a pint, discuss the flag, and get your head unfuzzled. Your sense of humour is underappreciated here. 😛

Yes.

What...

Chris, congratulations on searching before asking. You'd be surprised how many questions get asked over and over and over, often using the same terminology. 🙂

They need a new how-to book: SQL for Window-Washers.

I keep telling you Lynn, just don't look at his stuff and you will enjoy much more serenity.

😛