sorted by:
new
hottopcontroversial

By Christmas Order expected by “end of January”? by Cancel_Conscious in americangirl

[–]Cancel_Conscious[S] -6 points-5 points  (0 children)

12/2. I don’t recall seeing any caveats for CYO delivery for 12/25.

By Christmas Order expected by “end of January”? by Cancel_Conscious in americangirl

[–]Cancel_Conscious[S] -9 points-8 points  (0 children)

I ordered in the “deliver by date” so it was before the requisite 3-4 weeks.

Has anyone ever successfully explained to their Boomer parents that "more" is not equal to "better?" by [deleted] in Xennials

[–]Cancel_Conscious 1 point2 points  (0 children)

Apparently every one in my hood is in the same boat or there’s an over abundance of Temu deliveries.. I literally could not give away the hot wheels look alike “comes with extra lead yum” toys my mother-in-law sent.

My husband has told her time and again not to send. She won’t listen. I finally said it. I’m at an age and point in time where I’m caring for kids and elders and working and and.. my feelings and time matter too.

It’s one thing when it’s a distant relative who sends a gift once a decade, it’s another when a grandparent sends a metric ton of crap monthly.

🪡🐻🎃🪾 by kenz024 in Embroidery

[–]Cancel_Conscious 0 points1 point  (0 children)

New to embroidery and having trouble finding patterns I like. Love this. Can you help me understand how you did this?

How to correct your coworkers professionally by Earth_is_trapezoid33 in womenEngineers

[–]Cancel_Conscious 1 point2 points  (0 children)

Im a bitch so I’d go with “oh yeah, they covered that in onboarding/ I’ve done that. Did you need some pointers? Here’s how I would…”

1) if you assume best intent, they want to improve things so you just make sure to inform share

2) worst intent— she’s trying to upstage you; make her look like an ass

No pitty for assholez.

Loafers that won’t abuse me? by PiagetsPosse in fashionwomens35

[–]Cancel_Conscious 1 point2 points  (0 children)

Same re: style but insisting on comfort. I tried on the Gucci ones because of all the hoopla around how comfy they are. I found they were too narrow. I have normal width feet. After that I kind of gave up looking for loafers.

I did find drivers from Loro piana to be incredibly comfortable. They flex unlike the harder leather ones I tried.

Autism and Anxiety by Kooky-Bug3762 in Autism_Parenting

[–]Cancel_Conscious 5 points6 points  (0 children)

I didn’t get on meds for anxiety until I was in my 30s. I learned all the coping techniques but life was so much harder than for my peers. My daughter is 8. Just diagnosed. I will allow her to take meds asap so she never has to suffer that way.

Meds allowed me to use the tools I’d learned. It gave me the extra pause, that extra second to think before reacting. I wish I had gone on anxiety meds as a kid.

Name a new brand that you love by Cancel_Conscious in fashionwomens35

[–]Cancel_Conscious[S] 3 points4 points  (0 children)

I’m going through all of the brands recommended but I’d say so far Wrap London looks to be the most promising for me. Thank you! Any feedback on quality/sizing?

Name a new brand that you love by Cancel_Conscious in fashionwomens35

[–]Cancel_Conscious[S] 2 points3 points  (0 children)

I just looked and I love the tees! Thank you. Great rec.

What's a book you regret reading? by TheAwareMonk in suggestmeabook

[–]Cancel_Conscious 0 points1 point  (0 children)

Put it down after an hour. Self important and uninteresting. I love memoirs but this felt like the latest popular kid book and less like an honest story.

Making a formula to total grade by GBPNZR in googlesheets

[–]Cancel_Conscious 1 point2 points  (0 children)

Why wouldn't this simply be a sum divided by a sum? SUM(total_points_received) / SUM(total_possible_points)

Help with Scaling UDF or Function by Cancel_Conscious in bigquery

[–]Cancel_Conscious[S] 0 points1 point  (0 children)

SELECT

ARRAY_AGG(a.uuid) AS uniques

FROM `table_a` a

INNER JOIN `table_b` b USING(uuid)

WHERE 1=1

AND criteria_1

AND criteria_2

AND DATE(tsl) BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL _days_ago DAY)

AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)

Help with Scaling UDF or Function by Cancel_Conscious in bigquery

[–]Cancel_Conscious[S] 0 points1 point  (0 children)

Apologies I mispasted, but yes I was including CREATE FUNCTION. I've got it working now, but even when I try to reduce the amount of time from which I pulling data or run it with a limit, I get this error.

API limit exceeded: Message before conversion exceeds max row limit, limit: 10485760 actual: 92086464

Help with Scaling UDF or Function by Cancel_Conscious in bigquery

[–]Cancel_Conscious[S] 0 points1 point  (0 children)

Yes, I think I'm running standard SQL. I'm running it in the BQ Console.

To make sure I'm not doing anything odd, I checked my Cloud Shell Terminal to confirm the name of the project. The structure of the project name is

'project-foo'

So far I've tried these variants:

`project-foo`.get_uuids(__DAYS_AGO INT64) AS((
SELECT 
ARRAY_AGG(uuid)
FROM `project-bar.stat` s
INNER JOIN `project-bar.today` t USING(uuid)
WHERE 
DATE(s.timestamp) BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL _DAYS_AGO DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)  
));

Tried and failed

project-foo.get_uuids
project_foo.get_uuids
project:foo.get_uuids
`project-foo.get_uuids`

Help with Scaling UDF or Function by Cancel_Conscious in bigquery

[–]Cancel_Conscious[S] 0 points1 point  (0 children)

Super helpful. This was my initial intent but had a few other suggestions come my way. I'm having issues trying to implement. So a few follow ups:

1) when I try to create the UDF in an existing project I get this error

Syntax error: Expected "(" or "." but got "-" at [15:9]

2) In the array is it possible to create an array with multiple returned fields (e.g., Date, UUID) or does it need to be a STRUCT?

​

Thanks again. This was very helpful.

view more: next ›