I think that's working longer.

Harder means doing things that are more challenging and more risky,...

It's not clear. Are you saying all permutations of numbers from one table, including non-existent values?

Because 44 isn't a permutation that's a combination of your input set. However if you...

A cross join will give you all combinations.

Dropping into a new table with an identity property will give you a count. Or you could use ROW_NUMBER() to artificially generate these...

Grant Fritchey (5/17/2011)

---

True, but this one time, I'm taking the supposed high road. I've posted that I have sessions. I'm done. Vote or not. I'm in or not. I'd love...

OCTom (5/17/2011)

---

Steve,

It's interesting that you mention plumbing. I spent most of last weekend replacing piping in my house. I find plumbing to be easy and enjoyable. I can sweat pipes...

dma-669038 (5/17/2011)

---

To me 'hard' is finding energy and smartness to pack as much as you can do in the time you have. Say i have 3 tasks to do -...

congrats

Kiara (5/17/2011)

---

Steve, the ordering issue is not that the results are in a different order, but that they are *numbered* results.

1. Vinay, Anup, Amit 2. Vinay, , Amit 3. NULL...

Ninja's_RGR'us (5/17/2011)

---

Why are those the only 2 options?

Why can't we have fun getting done what needs to be done and go home after that? No need for long NOR...

Balance (5/17/2011)

---

What frustrates me is that almost every business I've worked at has rewarded people who are visible for long hours rather than those who have worked hard and are...

True, though the difficulty is relative. Plumbing mystifies me and it's "hard",...

Thanks for the update. That's essentially what a few people listed as a workaround.

tabraham 36699 (5/17/2011)

---

Another ticky tack problem. Sure, I said 2, because the results were the same, just in a different order. It was the last of the two matching result...

Formatting has been corrected.

There is a download at the bottom of the article in...