Steve, the German laws have more to do about enforcing a level playing field across all employers than it has to do with the individual. Without such statute limits employers...

Steve, the way you describe it I think you're confusing ideas with evidence.

Data is never going to tell you what to do directly. For that you'd need an idea.

Once you...

I have an issue with options 1 and 2 - if @aa = @xxx then none of the other 'SET's should happen, but saying @AA = @XXX AND @XXXCount >...

So should the question be what do we do with all the people industry refuses to employ?

and that the first computer bug was a real bug....

I don't wish to create an "excuse list" but most of the time I get the developer hitting a screwy problem and blaming 'security settings' stopping him from working out...

I'm not attempting to say HAVING without GROUP BY is invalid, and yes adding MAX(col2) to the selected columns I would then expect the behaviour you describe (and I would...

Given that 'having' should be executed after the aggregate has been formed, and code2 isn't in the column list, I don't see why the line is even valid - it...