May 9, 2008 at 1:40 am
Q (5/8/2008)
Since this won't occur until 2068 we are in the clear. The Mayan calendar says that Dec 21 2012 will be the end. I believe that corresponds whith our sun being in the center of the Galaxy. I guess that also takes care of the Social Security problems! 😉
Nah. Just that the Mayans concentrated too much on chocolate and the coca leaf to expect a future later than 2012. The world'll carry on after that date, but the Mayans just won't notice it ;).
**Disclaimer - this is not a serious attempt at racial profiling, and anyway, I'm with them on the subject of chocolate**
Semper in excretia, suus solum profundum variat
May 9, 2008 at 1:43 am
Semper in chocolate, sumus solum profundum variat
Yum!
Hiding under a desk from SSIS Implemenation Work :crazy:
May 13, 2008 at 5:48 am
for sql 2005 also it works
May 13, 2008 at 5:51 am
:D:D:D:D:D:D:D
Another Mode 80 user!
:D:D:D:D:D:D:D
Hiding under a desk from SSIS Implemenation Work :crazy:
May 21, 2008 at 4:21 am
Shaun - it's gone a whole week without another post to this thread!!!!
At long last it might be dead 😀
May 21, 2008 at 4:22 am
kevriley (5/21/2008)
Shaun - it's gone a whole week without another post to this thread!!!!At long last it might be dead 😀
Nope - you posted 😀 oh no so did I! :Whistling:
Hiding under a desk from SSIS Implemenation Work :crazy:
June 6, 2008 at 1:34 am
Running on SQL 2000 - Answer is wrong
begin tran
create table stud_mast (dob datetime, aaa int)
insert into stud_mast values ('1 feb 2008', 1)
insert into stud_mast values ('1 jan 2008', 1)
insert into stud_mast values ('1 mar 2008', 1)
select dob, * from stud_mast order by dob desc
rollback tran
--Results
2008-03-01 00:00:00.0002008-03-01 00:00:00.0001
2008-02-01 00:00:00.0002008-02-01 00:00:00.0001
2008-01-01 00:00:00.0002008-01-01 00:00:00.0001
June 6, 2008 at 1:46 am
With the greatest of respect, the original question was asked on 29th March. It's now the 6th June, so I suspect that might have provided enough time to read at least enough of the thread to realise your point has been discussed before.
Several times, in fact.
Semper in excretia, suus solum profundum variat
July 15, 2008 at 6:00 pm
If table is owned by dbo then this query returns results as expected in SQL Server 2000.
select hire_date, * from employee order by hire_date desc
July 16, 2008 at 1:34 am
oh dear..... and so it continues......
Hiding under a desk from SSIS Implemenation Work :crazy:
August 28, 2008 at 7:27 am
Excuse me but this works just fine on SQL 2000..
August 28, 2008 at 7:36 am
:D:D:D:D:D:D
Still going kev!
:D:D:D:D:D:D
necro.............................................................;)
Hiding under a desk from SSIS Implemenation Work :crazy:
August 28, 2008 at 7:37 am
I knew you'd pick this one up Shaun!
August 28, 2008 at 7:45 am
mariosiko (8/28/2008)
Excuse me but this works just fine on SQL 2000..
Not exactly, but thats another story......(read the thread fully).
Please don't necro dead threads (17th July - 28th August is a long time).
(:w00t: 2 more points for me :w00t: )
Hiding under a desk from SSIS Implemenation Work :crazy:
October 3, 2008 at 2:16 am
it's working for sql 2005 express
select vchfirstname,* from user order by vchfirstname desc
Viewing 15 posts - 166 through 180 (of 182 total)
You must be logged in to reply to this topic. Login to reply