|
den2k88 wrote: but we torture and kill only software. In the worst possible ways
Also we do, to the innocent-first-time-lounge-tech-question-poster.
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
Yup!
|
|
|
|
|
And Generalissimo Francisco Franco?
|
|
|
|
|
This breaking news just in, Generalissimo Francisco Franco is still dead!
"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
|
|
|
|
|
As is Hitler!
There... I did it. Someone had to. It was inevitable!
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
|
Vunic wrote: I got furious & shouted at my wife
Couch for you tonight!
|
|
|
|
|
Marc Clifton wrote: Couch for you tonight!
Slightly bigger for shredding. But still looks like a plan
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
First, say thank you, and I'm sorry.
Then you can start planning your revenge.
|
|
|
|
|
You can pop round and shred ours if you like, we have two large bags of the stuff.
Its fun at first but our shredder only takes 4-5 A4 sheets at once, after a while it gets a bit of a chore.
|
|
|
|
|
KennethKennedy wrote: Its fun at first but our shredder only takes 4-5 A4 sheets at once
Works for any size [^]
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
Thanks, I've got something similar already, I will try it tonight.
It will probably work best if I leave the paper in the bag and just shred the whole lot.
|
|
|
|
|
KennethKennedy wrote: It will probably work best if I leave the paper in the bag and just shred the whole lot
More materials, more noise. More noise, more job satisfaction.
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
I bring them to my parents' house. They have two wood ovens and they burn paper like nobody's business.
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
|
|
|
|
|
sorry it's late - a bit of a panic at work.... try this:
Cad blue! (10)
It's a SPOONERISM, innit?
(Hey, if OG can get away with his PARADOX the other week.....)
modified 20-Nov-17 8:04am.
|
|
|
|
|
*Groan*
This space for rent
|
|
|
|
|
Oh dear oh dear
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel).
I worked on it like 15 years back and never touched sql script.
So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------
Too much of good is bad,mix some evil in it
|
|
|
|
|
Repeat after me:
SELECT * FROM
someting AS st INNER JOIN
somethingelse AS se ON se.SomethingId = st.Id
Shirley this already brought it all back, right?
I have lived with several Zen masters - all of them were cats.
|
|
|
|
|
Arrrgh! NOOOOO!
SELECT st.TingOne, st.TingTwo, se.TingThree FROM
someting AS st INNER JOIN
somethingelse AS se ON se.SomethingId = st.Id
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Try typing "SQL SELECT" into Google.
|
|
|
|
|
select * from google
... About 1,040,000,000 results (0.50 seconds)
pfffft, is that all they have? disappointing!
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
W3Schools cover it all, but can be a bit "brick wall" from time to time.
This is OK: SQL Tutorial - Learn SQL Query Programming Language[^]
And there are some very handy bits added in the last 15 years such as LEAD and LAG which give you access to the next and previous row in a dataset.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: And there are some very handy bits added in the last 15 years such as LEAD and LAG
be careful though, some people haven't upgraded for even longer,
others, dare I say it, use access
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
Some of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|