Links 31 July 2020

Global Macro / Markets / Investing:

Americas:

Europe:

Asia:

Trans-Tasman:

Leith van Onselen
Latest posts by Leith van Onselen (see all)

Comments

  1. haroldusMEMBER

    OK freaks I’m on a CTE mission
    https://modern-sql.com/feature/with

    So you end up with

    /*define the CTEs*/

    WITH query_name1 AS
    (
    SELECT ... blah blah blah
    )

    , query_name2 AS
    (
    SELECT ...blah2 blah2
    )

    /*body of query, can access the data in CTEs that were defined above*/
    SELECT *

    FROM
    query_name1

    JOIN

    query_name2
    on key.query_name1 = key.query_name2
    and thing.query_name1 = thing.query_name2

    WHERE stuff = something

    ORDER BY 4,3 desc,1,8
    ;commit\p\g

    • haroldusMEMBER

      It’s a good idea to do joins in the FROM not the WHERE.

      FROM is to add sh!t, WHERE is to cut sh!t out.

      • boomengineeringMEMBER

        Good work Harry, now off to bye, bye, or you ” ,couldn’t get up in the morning”

        • haroldusMEMBER

          Data is not clean. Can’t do a straight UPDATE. Things are lookin bad.

          Needs humans looking at it. Not me.

          • boomengineeringMEMBER

            That human could be you after clearing your head. After frying my brain accepting jobs that no one else could/would do I always wake up with the answer because your subconscious brain is smarter than you are.

          • haroldusMEMBER

            I see what you mean. But what I mean is, if you want me to upload your data, you need to make sure it’s right.

            I’m the homunculus that’ll INSERT it, but you need to make sure it matches our db.

            Not talking bout you booma.

          • boomengineeringMEMBER

            Ok, we have a problem Houston. Akin to spaghetti wiring mixed in with obsolete wiring, sorting out the sheep from the goats compounded by someone previous putting the good ones in the wrong terminals . Btw of course you weren’t referring to me

        • haroldusMEMBER

          What are you doing up booma?

          I live on no sleep, and I’ll be dead before you.

          • boomengineeringMEMBER

            False economy, go to bed early for bike or surf then wake up too early which defeats the purpose.

          • boomengineeringMEMBER

            That wiring nightmare describes a job in Surry Hills that the boss trained as a mechanic found loose wires, so he just connected them to any terminal.

    • reusachtigeMEMBER

      OMG! That’s got to be one of the most boringest things I’ve ever glanced over. It just confirms why I don’t like IT types.

    • CTEs can be handy, but if it gets too messy or slow I would break it down with temp tables.

    • The Traveling Wilbur

      I’m blocked. Read that that you wanted help with “WHERE stuff something” and can’t move on. Please clear buffers. And ctrl+c. Heh.

    • For those, in disarray about golds sell-off today…

      Let me remind you its traded higher for nine days and has hit records in USD terms all week.

      It went from $1800 – $1900 in 5 days

      It has gone from $1900 – to presently $1950 this week.

      Fundamentals remain…

  2. BradleyMEMBER

    The Guardian and other truth deniers are upset the perps have been named and shamed in the QLD outbreak – https://www.theguardian.com/australia-news/2020/jul/30/naming-brisbane-women-risks-a-second-wave-of-covid-related-racial-hostility-commission
    “They didn’t identify the guards involved in the Melbourne hotel debacle ” but if they did , we would get to see the bigger picture – immigration has massive downsides, again. Just close the borders properly for a few years FFS. We’ve had it with the program, it stinks.

  3. https://www.smh.com.au/world/asia/must-be-done-in-three-days-officials-race-to-stamp-out-new-outbreak-20200730-p55h2j.html
    ‘Must be done in three days’: Officials race to stamp out new Vietnam outbreak

    another “successful” Asian country “failing” – it doesn’t matter how totalitarian a country is … free flying coronavirus doesn’t care
    Taiwan may also be on the way …

    Paraguay and Uruguay – the only “successful” South American countries also going through a second wave, …
    in Europe some of the most “successful” countries are getting second waves (Malta, Montenegro, Austria, Slovakia, Luxembourg, even Iceland)

      • repetitive?
        I thought these countries were all successful and on the track to get life back to normal

        • With the vast majority of the world populated by humans with covid-naive immune systems, and asymptomatic carriers, we can expect outbreaks to keep occurring as long as any form of travel occurs.

          Obviously.

          The thing is, what to do about it. Throw up our hands and declare it’s all too hard, as you suggest, or combat each outbreak when it occurs while we wait for a vaccine or drug to make it less lethal and less damaging?

          • BradleyMEMBER

            Stopping the planes both for environmental and bio security reasons makes perfect sense. No more immigration cargo cultism please.

          • The Australian populace and economy are deeply and profoundly addicted to the Immigration drug, not to mention the Tourism drug. Withdrawal will be agonizing and the current pollies don’t have the balls to impose it.

          • Arthur Schopenhauer

            Both major parties are locked into the non-productive population Ponzi. To close the borders & keep people in jobs, there needs a complete RE-build of the economy away from residential construction.
            Hard thing to do, with so many vested interests opposing it.

        • When arguing with bores, one always runs the risk of becoming boring oneself. It’s the old saying: never to wrestle with a pig. You get dirty, and besides, the pig likes it

  4. migtronixMEMBER

    “#Canberra 31 July 3:50AM

    Min -4°C
    Max 14°C
    Now -1.8°C FL minus 4.1c

    Friday Patchy fog in the early morning. Areas of morning frost. Sunny day. Light winds.
    @randlight @judbell43 @RBJRON @belungerer https://t.co/2sPcwWeOB0

    Its 3 feels like -3 here….

  5. migtronixMEMBER

    Trump is so disgustingly fat he constantly leans forward whenever he’s on camera to hide his massive gut.

    Fattest dumbest president I’ve ever heard of…

    • And he’s going carry several million fat , dumb Americans with him along the ‘rigged election’ bandwagon. They’ll be wound up like a cheap clock on a bomb come November!!!

    • It’s the fat between his ears that worries me. There used to be an insult when I was young: “fathead“. Trump personifies.

      • If you have been following my comments on this you’d know I was open about draining $20k myself.

        That ATO weren’t verifying eligibility is much like their foreign buyer approvals process I guess.

    • What LvO calls “dead-end degrees”. Maybe she could ask that BIG NERD up there to help her to #learntocode #tosomedegree

  6. My prediction for today: Trump will quit, he will not fight the election. He knows he’s going to lose and will not put himself through the fight. Mental “bone spurs”, I suppose.

    • drsmithyMEMBER

      The anonymous administrator of the page, of Melbourne’s southeast, told Daily Mail Australia he was ‘very surprised by the amount of agents submitting their own application to feature’.

      Clearly the anonymous administrator is a filthy renter.