|
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[^]
|
|
|
|
|
Eddy Vluggen wrote: ome of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable
yup, I'm one of those too, standard, portable, readable.
...in fact didn't know what LEAD and LAG was till OG mentioned it in this thread - had to google it, and 90% of my work involves SQL databases
- a lot lately on FireBird 1.5 which is old, has almost no extensions, but it is SQL92, and that's all that matters.
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
Lopatir wrote: yup, I'm one of those too, standard, portable, readable. Not as sexy as the cloud, but plain and boring - which is a good thing sometimes
Lopatir wrote: it is SQL92, and that's all that matters Not all, but most; if you're programming directly against a specific database-provider you'd still have a lot of database-specific code. If you program against the interfaces and you use SQL92, then changing the type of database should not be much of a problem.
In that case, any database that has a database-provider in .NET and is SQL92-compliant will work. It's the difference between telling the customer that you use "database X, version Y" and telling the customer "any SQL92 DB you like or have".
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|