Bonus SQL Pivot (% totals)

Probably something you'll want to do is summarise the pivot tables I noted earlier. That's not too hard - but you'll need to add an additional column to do you summing on (I reused IP since my table had no ID's to count):

Read more

SQL Pivots for the rest of us

Every time I have to build a SQL pivot I can't remember how to do it and end up searching online and struggle to work out what the heck people are talking about in their examples and spend ages looking at "sales" data examples, etc. that are overly complicated for my simple pivo…

Read more

Weekend Reads

I've been watching the Handmaid's Tale with rapt attention - and the Guardian drops some hints of what it would like to see next season and what made this season work so well and it's spot on with many of it's observations but doesn't give anywhere near enough credit to the cast…

Read more

Tuesday reads

I found reading this piece on a gun crime victim's family depressing but enlightening - and reminded me how fortunate I am to live in a country where guns are exceedingly rare. Contrast this with the struggles of a " Boy who loves too much " makes you realise it's a complex worl…

Read more