The point is;-

2000/mode 8 is flawed and should report an error, it does not. 😀

ORDER BY clause should require unique column naming in the select

or

as suggested in the answer the...

bimpe_d - your 2005 is running in 2000 (version 8) compatibility mode. 🙂

version 9 mode - native 2005 fails.

(2000 is flawed).

--Shaun

Points Smointz!

Who cares (apart from the people you know/work with/'the point hound(s)')? 🙂

Doesn't mean anything really its not like you get paid - they don't make prizes!

Along as we all...

but george - 'database administration is all about deception'

-Shaun Tzu's Art of DB Admin. 🙂

SQL2K is obviously a bit broken then as trying to use such a resultant table for further SQL will cause all sorts of problems.

Logically everyone should have thought about it...

Obviously a version specific question, without specifying the version doh!

Let's shoot/maim/harrass (delete as appropriate to your annoyance level) the question poster. 😀

This is an IT forum - precision is everything...

Seriously? 'People' (Citizens of the USA and other countries) don't reboot their PC's on a daily basis!

This is Windows! (Kick the unlucky person into the big pit!) It's applications have...

The only instance I can think of where it is appropriate is for a critical O/S or hardware failure, maybe even heaven forbid virus infection/infestation.

such as a 'shut me down...

P Jones;

I have definately seen at least one of those types of dialog, can't remember where.

Makes you want to throw the whole thing out of the window!

At least MS gives...

Totally agree that the recurring pop-up modal dialog is a pain in the butt!

I play games on an evening sometimes which switch the display to a different mode and assume...

Question must have been - which years for the 'American' war of independence?

There have been other WoI. My Citizens of the USA amigos or CUSAs for short plural (pronounced cussers)....

I think there will be lots of RBAR done by programmers due to this, as they think and are trained in procedural programming methods not set based methods.

Weather has been really wild all week in the North East - specially the gale force winds. 😀

I always consider long distance travel an adventure.

I think he just want's to...

Mr Jones -

'...especially the UK.'

explain yourself please?

Thats alright then 😀

Yeah waiting in airports after coming in over night from the states is a real bitch, I landed in Heathrow about 07:30 GMT and the connecting flight...