muddydogs.life
The "Using... " posts or how-to do something useful
http://www.muddydogs.life/2015/08/01/the-using-posts
The Using . posts or how-to do something useful. In this blog you'll find a whole series of posts that come under the collective heading of Using. Might be Excel, or SQL or Tableau, etc. I think most people would call them How-To's. So why'd you call them 'Using', then? Simple, because I wrote most of them while I was. SQL you get the idea :). So when I was trying to come up with a tag that could group them all together,. Most of them were written as aide memoires. What do they contain? A self proclaimed...
muddydogs.life
Teradata SQL: To find the first or last record in a sequence
http://www.muddydogs.life/2015/08/03/sql-to-find-the-first-or-last-record
Using Teradata SQL: How to find the first or last record in a sequence. If your reading a lot of records from a database and you need to find the first or last record in a sequence, you can do this in MS SQL by using TOP 1, or in MySQL by using LIMIT 1. But TOP and LIMIT don't exist in Teradata SQL so we need another way to find it. That way is by using the QUALIFY . OVER . PARTITION construct. SELECT * FROM EMP QUALIFY ROW NUMBER() OVER ( PARTITION BY EMP NAME ORDER BY DATE EFFECTIVE DESC) = 1;`. A self...
muddydogs.life
Using Teradata SQL: Create a table from another table or select statement
http://www.muddydogs.life/2015/08/10/using-teradata-sql-create-a-table-from-another-table
Using Teradata SQL: Create a table from another table or select statement. OK, this one is fairly basic for anyone who regularly uses SQL, but it's a neat trick if you're not familiar with it. Normally when you create a table you have to specify all the fields and their formats in the CREATE statement. Then you populate it with an INSERT statement. But there is an alternative . The 'CREATE TABLE . AS' statement. This little marvel can be used to:. Create a full copy of an existing table. CREATE TABLE tes...
muddydogs.life
Jamie Whitehorn - Page 1 - Random Thoughts … and Muddy Dogs
http://www.muddydogs.life/author/jamie-whitehorn
A self proclaimed geek who loves technology, data, computers, photography and science; but balances this by spending time with his wonderful better half and their dogs and horses in the countryside. Http:/ www.idatasci.com. Page 1 of 5. Older Posts →. I'm now an Irish Citizen. Well, as well as being a British citizen and a New Zealand citizen I'm now an Irish citizen as well. OK, I know I'm a bit ». Trello - turning Gold into .what? Don't pre-judge, and always give people a change to explain. Or 60 secon...
muddydogs.life
The Paperless Dream - Or how to live at home without paper
http://www.muddydogs.life/2015/07/30/paperless-existence
The Paperless Dream - Or how to live at home without paper. A tale of DEVONthink. And the Fujitsu ScanSnap S1300i for PC/MAC. A long time ago in a galaxy far, far away. People discovered the home computer. Lots of things were promised, including a brave new world where paper would be a thing of the past, all documents would exist as electronic copies. The filing cabinets would be emptied and would gather dust in this brave new world. The era of the Paperless Office was upon us . Every so often, in the in...
SOCIAL ENGAGEMENT