I'm not sure what you mean by "extragovernmental entity" but this is what CERN themselves say about what they are, and it's certainly not a private company:

"CERN is run by...

sturner (6/26/2012)

archie flockhart (6/26/2012)

Or you need to accept that there are some things...

jbnv (6/26/2012)

HTML was developed by Tim Berners-Lee...

Or you need to accept that there are some things which are worth...

But if you asked anyone at Lehmann at the time they would have told you that...

The worship of 'risk-takers' seems to me to be based, at least in large part, on "survival bias": pointing at a few lucky people whose risks paid off.

There...

[ In SQL Server, there are multiple options: should 1/2 be treated as 5.00E-01 (FLOAT) or as 0.5 (DECIMAL)? What about 1/3? Is it 3.33333333333333E-01, or 0.3, 0.33, 0.333, 0.3333,...

Yes, I can see a reason for having an 'integer division' operation. That doesn't mean it needed to be the default behaviour whenever two integers are divided.

And it isn't as...

Hugo

You're right that as long as the behaviour is documented we can work with it - too late to change the behaviour now anyway ! - but a choice was...

I know this is how it does actually work, but does the behaviour not strike people as a bit strange ?

SQL Server is smart enough, when dividing two quantities that...

It's because of the order of operations: when written this way the UNION happens first and removes duplicates in t2 and t3, then the result is combined with t1...

Explanation is wrong: you can get multiple rows even if you use UNION in the query.

You can try it using the tables in the question:

select col from #t2

union

select col...

It's been a long...

I'd be interested to know what problems require the calculation of a product from each row in a query in this way.

Presumably also, you'd need to be aware of the...

In the BOL, I still don't see anything that goes beyond "for some reason" as an explanation of why you can't convert an empty string to decimal, while you can...