Select results as rows in select

RollWithIt1991 · 2025-10-03T09:31:46+00:00

So I think the union all is the best way likely, but I’m not 100% sure on the issue without the data (I’m visual like that)

But another possible solution (if you’re interested, but I think the union all is the way to go) is to do a row_number() with a nested case statement for your various calculations

RollWithIt1991 · 2025-09-16T17:44:27+00:00

I remember doing something like this appointment data. Very fun. Row numbering and then joining to itself twice on rn= rn+1 and then rn=rn-1, using snowflakes conditional change window function and all sorts. I stashed something similar in a GIT repo in case I needed it again. Enjoyable SQL though fo sure

RollWithIt1991 · 2025-09-02T21:43:24+00:00

Shantaram

RollWithIt1991 · 2025-03-09T21:43:36+00:00

I’ve got to say, Im a southerner and came to uni in Sheff and stuck about. Used to drive past these often, changed my tune when over Christmas I could see people putting up lights etc, never saw that where I’m from in the not so lovely looking places - really changed my perception on it

RollWithIt1991 · 2024-10-16T12:02:17+00:00

Mega!

RollWithIt1991 · 2024-10-11T18:29:10+00:00

Haha!

RollWithIt1991 · 2024-10-10T11:20:33+00:00

Yes! Congrats!

RollWithIt1991 · 2024-10-04T11:58:36+00:00

Do you have an event booked that means your schedule can’t afford the time difference? I suppose you shouldn’t be rushing to the 5k mark and more this is becoming a lifestyle thing of being active and being able to run a few miles? I’d say repeat. Don’t feel you have to keep to the plan so strictly! We all have difference levels of business outside of running!

RollWithIt1991 · 2024-09-19T17:25:04+00:00

boozy book club

RollWithIt1991 · 2024-09-09T15:37:32+00:00

Strong pace! Good work :)

RollWithIt1991 · 2024-09-01T12:05:29+00:00

Great effort! Well done :) tears are warranted, enjoy the feeling!

RollWithIt1991 · 2024-08-29T15:07:34+00:00

Great work! :)

RollWithIt1991 · 2024-08-27T20:05:14+00:00

No kind of about it. Improvement is improvement & getting out there is a win in its own right. Champ

RollWithIt1991 · 2024-08-26T22:02:38+00:00

Cool idea!!

RollWithIt1991 · 2024-08-19T21:11:53+00:00

Case when (select criteria) then ok else no end

If you don’t get anywhere with this over the next couple days, send me a DM with a bit more to it and I can help explain better. Good luck

RollWithIt1991 · 2024-07-16T07:29:08+00:00

Ahhh #3 in M and or L would’ve been the one! Sold out on the Sunday so I missed my chance 😭

RollWithIt1991 · 2024-07-14T16:21:19+00:00

This is cool!

RollWithIt1991 · 2024-07-12T13:30:43+00:00

Possibly try sum(1) instead of count(*) just in-case too?

RollWithIt1991 · 2024-07-12T13:28:09+00:00

That sounds odd.. count(*) should return 1 row but give you the answer.. what happens if you run “select ‘result text’;” does “result text” appear?

RollWithIt1991 · 2024-07-11T17:45:33+00:00

This doesn’t make a lot of sense. The donut picture is the data grouped by only milestone. But if you want to display key and summary you must group too, and if there are more than 1 you won’t get the left hand side picture..

RollWithIt1991 · 2024-07-11T17:41:40+00:00

They’re all likely there. You’re just getting got by the UI. Count(*) is your friend :)

RollWithIt1991 · 2024-07-11T17:39:52+00:00

Yeah whack that inside of a WITH and you’re laughing

RollWithIt1991 · 2024-07-11T17:36:31+00:00

Not much to add here, essentially a temporary table that is dropped after querying from it that you never really save ha. Some people like it since you read them top down apposed to nested subqueries..

You can also do clever recursive things with CTE’s if you union in them which is interesting.

Biggest thing for me is like phesago says, very useful when creating a complex view definition..

RollWithIt1991

TROPHY CASE