Morning

aA chairde - Morning all!

@JohnK.N. Commented that follow upc is (part of accepted answer) 8s difficult since the "Last seejn" widget was removed! Any sign of that being reversed?

Morning

@Vérace Agree

However, the last point in the list is pretty on point: Try to follow back up on it if you can for a while and if after a few months nobody has responded with more details, then vote for it to be closed.

As for the revision of the last seen option: I don't think so.

Delete all questions, and start again

That has been done. See dot for details.

@Vérace in the list with the fiddle links, you have a line which seems odd:

> - Vérace "Pure SQL" method (

@ypercubeᵀᴹ - working on that as we speak! I know the fiddle is blank at the moment - I'm going to put in yours and also EB's without the RCTE's! Even playing field and all that! :-)

Morning

Good morning.

Would be nice to have a process that "vacuumed" all the old, unanswered questions - like, bump them once or twice, delete after a week if no responses.

I think for magic unicorn/useable answer perspective there isn't much motivation to answer a narrow question for a user who won't upvote/mark accepted and probably found a solution someplace else/just kludged it.

@McNets But I don't want to expend effort, I want things automated!

Even if the level of effort required to automate was greater than the effort to do things by hand because why else would I have gotten involved with computers? :)

@bbaird ohhh, these young ppl, always lazy!! :P

CTRL + C
ARROW DOWN | HOME | TAB | TAB | CTRL + V
ARROW DOWN | HOME | TAB | TAB | CTRL + V
ARROW DOWN | HOME | TAB | TAB | CTRL + V

old-school ----^

@ypercubeᵀᴹ - revised benchmarks (numbers table permitted). 2 of your answers in - the one which was marked as correct and also the one which you put in the fiddle above yesterday. For some reason, dbfiddle just won't work for me with the 340/570 parameters. In a way, it's just as well - I have control over what's happening on my own machine (nothing for the most part). Anyway, my revised answer is here - with corrections - I'm hoping that it will only require very minor changes from now on!

Benchmarking - it looks easy, it ain't! I really admire that guy on Phoronix!

@bbaird dba.stackexchange.com/help/roomba

@PaulWhite Every good idea has been done!

Gonna downvote questions a little more aggressively now

@bbaird and quite a few bad ones too 🙂

mumbles Like giving the kangaroo lover a star

@Vérace next you will be adding charts ;)

@ypercubeᵀᴹ - I was thinking along the lines of a few Tableau dashboards and an interpretative centre through the medium of Jazz dance?

@Vérace I can'r decipher that, lol.

too much Irish whisky my guess!

@bbaird good idea. Downvotes on questions are free, FYI

@ypercubeᵀᴹ - I've added a (absolutely final method) which uses the INTARRAY extension - this bit SELECT ARRAY_CAT(c.arr, SORT(c.arr, 'DESC')) - the SORT means that I don't have to do a second GENERATE_SERIES() and that seems to shave a few vital bits of a millisecond off the time! I think I've gone overboard on this now :-), so I'll stop there! Anyone would think that I didn't have a life! :-) Be very interested to see any improvements though...

What reporting tool do you prefer, SSRS or CrystalReports?

Scratched the above because the OP initially said they were using SQL 5.7 - I assumed MySQL - apparently now it's PostgreSQL - so the provided answer should apply!

@McNets PowerBI

@HannahVernon PowerBI is useful for statistics and analysis. I mean to print one order or a bill for instance.

@Vérace I'm going to work on this problem again

now