AndyD (4/10/2009)

---

The quantum guys say there is no way to predict the flip of a coin. Einstein would argue there is. IFF you knew all of the forces...

I have, but it was 20 years ago. My progression through...

Most of the work I do here supports "internal" clients. The parts that support external clients is only accessible via web based reports (CE). The work for the...

I'm stepping out on a limb here....

Didn't you...

YSLGuru (4/7/2009)

---

I'm going from memeory and it has been a while back but we ran into a problem where the order of the grouping did matter and it very well...

Michael Valentine Jones (4/6/2009)

---

YSLGuru (4/6/2009)

---

I don't see how the example you gave would give you different...

YSLGuru (4/6/2009)

---

For example in an apartment complex you may have several types of units. If you wanted a count of these and you grouped by Unit Type then Unit...

And the follow-up where,

select Col1, Col2, count(*)

from dbo.MyTable

GROUP BY Col1, Col2;

select Col1, Col2, count(*)

from dbo.MyTable

GROUP BY Col2, Col1;

Are not equal (in...

OTHERWISE .....

We could market the new linguistically challenged version SCL...

Super Confusing Langauge...

GSquared (4/3/2009)

---

Quite obviously, it is meant to be contained in the Group By, so why not implicitly include it? Sure, that may be a violation of the standard, but...

Having started my db work in EXEC, REXX, RAMIS (sp?), and the like, then moving on to procedural programming languages in college, Modula-2 for the most part, after college...

Too much of a substitute for actually going out and doing something. Live your reality, don't pretend.

Quite some time ago, I was the philanthropic chair of my fraternity. ...

We have an interesting chap here...

For some ungodly reason he ALWAYS composes his emails as follows. In the little box that says subject, he'll type:

"Topic: Some...

blandry (3/26/2009)

---

But if you knew that you would spend say 20 or 30 years in jail for such behavior, wouldn't that at least help deter this kind of thing? ...

AndyD (3/20/2009)

---

Wow, that is scary! And programmers get paid to write this pile of %#*@

You could always suggest that they save money by migrating to mySQL, or PostGreSQL, or even...