Geek Jokes

TOPIC CLOSED
TOPIC CLOSED
Author
Discussion

SwissJonese

1,393 posts

176 months

Monday 21st July 2014
quotequote all

Snowboy

8,028 posts

152 months

Monday 21st July 2014
quotequote all
marshalla said:
MagicalTrevor said:
And if you could make it:

SELECT *
FROM children
WHERE Upper(status) = 'NICE'
AND Upper(status) = 'NICE';

Just so the 'Nice' kids and 'NICE' kids get presents as well? wink
Should be sanitising and standardising on iynput.
But what about the 'very naughty' children,
Perhaps it should be;
upper(status) not like '%NAUGHTY%'

How about the 'quite nice' ones.
upper(status) like '%NICE%'


Look, I'm going to need to do a lot more analysis of the source data and review the requiremwnts before I can deal with this project correctly.

h0b0

7,617 posts

197 months

Monday 21st July 2014
quotequote all

clonmult

10,529 posts

210 months

Monday 21st July 2014
quotequote all
Snowboy said:
marshalla said:
MagicalTrevor said:
And if you could make it:

SELECT *
FROM children
WHERE Upper(status) = 'NICE'
AND Upper(status) = 'NICE';

Just so the 'Nice' kids and 'NICE' kids get presents as well? wink
Should be sanitising and standardising on iynput.
But what about the 'very naughty' children,
Perhaps it should be;
upper(status) not like '%NAUGHTY%'

How about the 'quite nice' ones.
upper(status) like '%NICE%'


Look, I'm going to need to do a lot more analysis of the source data and review the requiremwnts before I can deal with this project correctly.
Who in their right mind would store status as a text field?? Need to think of the possible values for status; very good, good, nice, average, a little naughty, naughty, really naughy, downright evil, running for public office. Values enumerated 10 through to whatever, steps of 10. So 40=average. Therefore status > 40 would be quicker and get the full range of "not good" kids.

MagicalTrevor

6,476 posts

230 months

Monday 21st July 2014
quotequote all
hehe

JonRB

74,597 posts

273 months

Tuesday 22nd July 2014
quotequote all

tribbles

3,976 posts

223 months

Tuesday 22nd July 2014
quotequote all
JonRB said:
biggrin

Love the Schrödinger one. And the Turing one.

Snowboy

8,028 posts

152 months

Tuesday 22nd July 2014
quotequote all
clonmult said:
Who in their right mind would store status as a text field?? Need to think of the possible values for status; very good, good, nice, average, a little naughty, naughty, really naughy, downright evil, running for public office. Values enumerated 10 through to whatever, steps of 10. So 40=average. Therefore status > 40 would be quicker and get the full range of "not good" kids.
Not to mention it's a global system; what about 'bon' or 'giocherellona' status.
Also it's been around for years, who knows what the source code looks like and how often it's been upgraded and altered.


Hooli

32,278 posts

201 months

Tuesday 22nd July 2014
quotequote all
Morningside said:
hehe

Vocal Minority

8,582 posts

153 months

Tuesday 22nd July 2014
quotequote all
Silver Smudger said:
hehe

Morningside

24,110 posts

230 months

Tuesday 22nd July 2014
quotequote all

frown

Morningside

24,110 posts

230 months

Tuesday 22nd July 2014
quotequote all
Vocal Minority said:
Silver Smudger said:
hehe

Insanity Magnet

616 posts

154 months

Tuesday 22nd July 2014
quotequote all
Morningside said:

frown
He's the spit of someone I used to work with (allowing for a few years back to the Ghostbusters era...) eek

JonRB

74,597 posts

273 months

Tuesday 22nd July 2014
quotequote all
Insanity Magnet said:
He's the spit of someone I used to work with (allowing for a few years back to the Ghostbusters era...) eek
Possibly. But its also true smile

K12beano

20,854 posts

276 months

Thursday 24th July 2014
quotequote all

SwissJonese

1,393 posts

176 months

Friday 25th July 2014
quotequote all

K12beano

20,854 posts

276 months

Tuesday 29th July 2014
quotequote all

K12beano

20,854 posts

276 months

Tuesday 29th July 2014
quotequote all
In France, the Apple-ication of alcohol is known as.....


..."Calvados"

LordGrover

33,546 posts

213 months

Thursday 31st July 2014
quotequote all
Not sure this qualifies as genuine geekery, will link only: click

Silver Smudger

3,299 posts

168 months

TOPIC CLOSED
TOPIC CLOSED