|
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[^]
|
|
|
|
|
I don't worry too much about portable - I just make sure I develop using the same version of SQL as the target production system: so currently SQL 2012 SP1.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
It is hardly a worry; but as good as MSSQL 2012 is, it still is a vendor lock in. Not a vendor that is likely to go bankrupt, but stranger things have happened. For using a bit less fewer new features, you get flexibility in return.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
. I miss those papers *dammit*!
