|
Not if I use the SQL_EBCDIC037_CP1_CS_AS collation! 
WITH cte As
(
SELECT '1 America' As CountryName
UNION SELECT 'Albania'
UNION SELECT 'Zimbabwe'
)
SELECT CountryName
FROM cte
ORDER BY CountryName COLLATE SQL_EBCDIC037_CP1_CS_AS;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Maybe we can make a new rule, count from bottom up.
Bryian Tan
|
|
|
|
|
Then I'll switch to using a standard collation: 
WITH cte As
(
SELECT '1 America' As CountryName
UNION SELECT 'Albania'
UNION SELECT 'Zimbabwe'
)
SELECT CountryName
FROM cte
ORDER BY CountryName DESC;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
A lot easier: Just put an underscore in front of it: _America. Done. You're gonna love it.
See, I'm better than Trump. Make me the president!
I'm gonna build a wall around my cubical and make Mexico pay for it!
|
|
|
|
|
Bryian Tan
|
|
|
|
|
If we're second, and America fails to get to #1, will that make us the #1 instead?
Or do we always stay one place behind America? 
|
|
|
|
|
Can always rename it [^] or push it in to Germany
Sin tack ear lol
Pressing the any key may be continuate
|
|
|
|
|
Why? After all Rammstein got it right:
We're all living in America, America is wunderbar
* CALL APOGEE, SAY AARDWOLF
* GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
* Never pay more than 20 bucks for a computer game.
* I'm a puny punmaker.
|
|
|
|
|
|
If that is the type of sh*t we are wasting our government's time with, we are in serious trouble. Especially with this[^] becoming a real issue.
Sudden Sun Death Syndrome (SSDS) is a very real concern which we should be raising awareness of. 156 billion suns die every year before they're just 1 billion years old.
While the military are doing their part, it simply isn't enough to make the amount of nukes needed to save those poor stars. - TWI2T3D (Reddit)
|
|
|
|
|
David O'Neil wrote: If that is the type of sh*t we are wasting our government's time with, we are in serious trouble
Perhaps it is due to the difference in time-zones, but from here it looked like that for quite a while now. Mind you, the Eurozone is still beating you lot in terms of sinking. If there's an absolute bottom in this race, our bureaucrats will find it and they will drill baby 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I feel bad for the turd country.
|
|
|
|
|
Bassam Abdul-Baki wrote: I feel bad for the turd country.
The easiest solution is often the best; any other country can become a province of the Netherlands. That way only the greatest two countries would remain 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Yesterday, by mid-afternoon (local time) it was 65F (18-19 C). Lovely weather.
Today . . . we're working on 12" +/- 4 (30cm +/- 10) snow.
Am I getting a bit too political if I say this isn't even remotely normal?
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Cycles like that in the 90s made some of my best snowday memories (because the combination generally fueled heavy snowfall), along with one of my worst when after 3x 12-16" snowfalls in two weeks it went to ~60 for about a week and destroyed the massive snow fort I'd built to bluff the older boys across the street: Broad U shaped about 3x5' interior, 4-5' high, walls that were 4' thick at the base tapering to 3' at the top; but without a single throwable snowball behind the wall. 
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Sounds like the makings of a fortified igloo.
I was in Chicago for the "Winter of '79" - alas, old enough to need to go places and not play in the snow. So much, they found some still unmelted in a quarry where it was dumped - in August.
Such weather is absolutely unprecedented (in my scores of years) - not that the weather can swing over a period of a week or so - but in less than 24 hours, from record heat to below-normal temps. Oddly, the moisture's coming from the west; the ocean is to my east. That's the thing; there's more and more "rare" weather events.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
W∴ Balboos wrote: I was in Chicago for the "Winter of '79"
That was awesome, one of the very few times we had off school, and jumping off the roof into a big pile-o-snow was about as fun as it got.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Do you remember the Trib (or Sun-Times?) had an iron-on for the occasion?
"I survived" and "Winter of '79" ?
Not only did I use it, but I still have the t-shirt (worn so thing it's almost transparent)!
Not being a kid, I had some really unpleasant memories about commuting on the EL from Rogers Park to Evanston, spending several hours for the few stops - and standing on the platform, above ground, in freezing howling wind, waiting for the transfer. Those heater's didn't do much.
Memories (! or ?)
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Don't recall the iron ons, the only ones I had at the time were KISS ones (hey I was in my early teens). But I do remember the political fallout for Bilandic (I had to sneak politics in somehow ). Ah `79, back when winters were winters (as an avid ice fisherman, I am lamenting the lack of ice around here currently).
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
W∴ Balboos wrote: That's the thing; there's more and more "rare" weather events.
I've read that in reality weather patterns across the globe have been in a rare "calm" for the last century or two. That things are only now returning to "normal".
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
Not a judgement on what you read!
These days, one can find and read pretty much anything about anything. The era of alternate facts and all that.
We live in an era, weather and otherwise, wherein the term "Alternate Facts" can actually be used with a straight face. We need no other reason in order to remind us just how f*cked things are and will be getting.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
W∴ Balboos wrote: These days, one can find and read pretty much anything about anything. The era of alternate facts and all that.
So what is one to do? We all know that using short term, local data to predict long term, global trends is not going to work. I cannot collect and analyze all the data from every source on all topics so I'm stuck with "trust". Who I "trust" and what level that "trust" entails varies but in the end you have to "trust" or you become a very dysfunctional person.
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
Nothing wrong in that paragraph - only the acceptable paradigm seems to have been warped.
Better said, warped overtly. There have always been lies, misrepresentations, &etc. (like Disraeli's Lies, Damn Lies, and Statistics of a century ago).
Further more, people tend to believe the facts that jive with their perception of reality (or hoped-for reality).
The paradigm shift, now, is that everyone can have a voice loud enough for everyone to hear. In a way, the information age really isn't! There's so much information and so much misinformation that they pretty much cancel out.
I try, as does everyone, to apply my areas of stronger knowledge where possible. Amongst these are chemical kinetics and a looked-for baseline so that a "fact" can be viewed with a frame of reference. So - we are, for example, putting "old carbon" back into the atmosphere.
What really surprises me is that anyone would expect nothing to change. One should not trivialize or politicize a fact and try to anticipate consequences and react to them without being influenced by some of the largest financial interests on the planet. That's why I say "Something's going to happen - the only argument is what".
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
W∴ Balboos wrote: The paradigm shift, now, is that everyone can have a voice loud enough for everyone to hear. In a way, the information age really isn't! There's so much information and so much misinformation that they pretty much cancel out.
Don't forget about the other paradigm shift... $$$$$$
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
Mike Mullikin wrote: Don't forget about the other paradigm shift... $$$$$$
That would only be a paradigm shift if money<=>power didn't do most of the talking that's listened to.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
