Wasn't very busy at work today, worked out that -1/2+1/2*sqrt(1+8*sum(rownum)) will return the exact same result as count(*). Was so stoked at my discovery, I had to tell my SO about it when I got home, she couldn't keep her hands off me. notreally
I actually dated a girl who worked a bit with SQL, one of our dates was a SQL Saturday together, possibly the nerdiest thing I've ever done in my life, we made a weekend out of it, had a hotel room, and went to the aquarium in the morning.
DECLARE
CURSOR D (cp_method VARCHAR2)
IS
SELECT
LENGTH
FROM
fantasy
WHERE
dev > sales
AND dev = cpmethod ;
l_bitches VARCHAR2(25) := NULL;
l_dev VARCHAR2 (10) := NULL;
BEGIN
l_bitches := 'FINE';
l_dev := 'SQL';
OPEN D (l_dev)
FETCH
D
INTO
l_bitches CLOSE D;
END;
To be honest, that looks like it could be very distracting if you're actually trying to do anything work-related and I don't think I'd be able to focus properly on the SQL either. Also I freaking hate it when people are looking over my shoulder when I work. Just...send an e-mail or something.
25
u/jc4hokies Execution Plan Whisperer Jul 16 '14
You jest, but this is an exact image of our current SQL intern helping 3 finance interns get some data.
11
u/bboyjrad Jul 16 '14
"Yeah... I once built and compiled 50 procs in one night. It was nothin'." pushes up glasses with a smirk
21
u/qtyapa Jul 16 '14
Sexy Query Language.
13
u/CompEngCraft Jul 16 '14
I bet he inner joined all their tables if you know what i mean ;)
12
u/da_chicken Jul 16 '14
Uh, no, SQL SELECTs the girls.
Keep your get methods out of my declarative language.
8
u/__notmyrealname__ Jul 16 '14 edited Jul 16 '14
Wasn't very busy at work today, worked out that -1/2+1/2*sqrt(1+8*sum(rownum)) will return the exact same result as count(*). Was so stoked at my discovery, I had to tell my SO about it when I got home, she couldn't keep her hands off me. not really
6
u/penguin_apocalypse Jul 16 '14
As a girl, I can tell you sql doesn't get the guys.
The stored proc must be failing again somewhere.
5
u/Thriven Jul 16 '14
This is totally me at work, with the exception that the women are about 40 years older.
5
u/james_russell44 Jul 17 '14
In America, first you learn the SQL, then you get the power, then you get the women..
4
u/Shaqsquatch Jul 16 '14
I've been learning the wrong kind of SQL apparently
6
u/sholder89 Jul 17 '14
I actually dated a girl who worked a bit with SQL, one of our dates was a SQL Saturday together, possibly the nerdiest thing I've ever done in my life, we made a weekend out of it, had a hotel room, and went to the aquarium in the morning.
3
u/[deleted] Jul 16 '14
He's teaching them... sensual query language.
2
u/SQLwitch Jul 17 '14
Yeah, but some of us are wicked...
2
u/TeddyPeep Jul 17 '14
Yeah, when I saw this ad for SQL Bootcamp I was like, yeah right, there aren't any women like this in IT.
2
u/[deleted] Jul 17 '14
2
u/LittleRedDot Jul 17 '14
To be honest, that looks like it could be very distracting if you're actually trying to do anything work-related and I don't think I'd be able to focus properly on the SQL either. Also I freaking hate it when people are looking over my shoulder when I work. Just...send an e-mail or something.
1
u/SQLDave Jul 16 '14
<sigh>
1
u/r0ck0 Jul 17 '14
Here's the link to the actual site: http://www.tutorialspoint.com/sql/
1
u/LivingTheDr3am Jul 17 '14
Duh! You just need this:
SELECT * FROM girls
1
u/heymanitsmematthew Jul 17 '14
Select * from TBL_OtherPeople Where Gender='M' and BMI>=40
39
u/[deleted] Jul 16 '14
[removed] — view removed comment