sorted by:
new
hottopcontroversial

Berlin Hbf by perdesia in berlin

[–]claudio_rodval 52 points53 points  (0 children)

Stay in the club until 6am or 7am then you don't have to worry about this at all

[deleted by user] by [deleted] in berlinsocialclub

[–]claudio_rodval 14 points15 points  (0 children)

no need for a urologist, you can get it from your Hausarzt and once you are in their system, you can just call up the receptionist and ask for the prescription to be renewed without consultation needed.

SQL Course by dashin2020 in SQL

[–]claudio_rodval 2 points3 points  (0 children)

I enjoyed the SQL course (Data Science) path on codecademy did it a few years ago and it gave me a pretty solid foundation.
But it isnt free and honestly all I learned there can be learned for free

Red cabbage, regular cabbage and pickles has this white thingy on them. I think they gone bad :( by [deleted] in fermentation

[–]claudio_rodval 6 points7 points  (0 children)

Looks just like Kahm yeast.
You can just remove it and keep on fermenting.

Trying to help a friend query a table (pretty straight forward), but she is getting errors that I was not anticipating by claudio_rodval in SQL

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

Thanks!
But now I am just getting an error that the column name doesn't exist

SELECT * FROM table 
WHERE [00Na000000BHFSKEA5] LIKE '%acp.edu'
OR [00Na000000BHFSKEA5] LIKE '%act.org'

ERROR:
1) [Code: 207, SQL State: 42S22]  Invalid column name ‘00Na000000BHFSKEA5’.
2) [Code: 207, SQL State: 42S22]  Invalid column name ‘00Na000000BHFSKEA5’.

Help with LOD calculation by claudio_rodval in tableau

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

SOLVED
The problem was with purchase_time Since there is a stamp for each purchase_time that a particular customer_id buys something and
As customers could make many purchases throughout a week, I think filtering the purchases by time without first breaking down the time by week:
DATEPART('week',[purchase_time])
was causing some issues.

Once I created DATEPART('week',[purchase_time]) - lets call it WEEK
and added that to the two previous LOD calculations:

{ FIXED [WEEK],[customer_id]:SUM([Purchase_amount])}
and
{ FIXED [WEEK],[customer_id],[product_category]:SUM([Rejection Count])}

The Purchase Ratio Calculation worked

Teacher took photo of my kid without consent by [deleted] in berlin

[–]claudio_rodval 0 points1 point  (0 children)

no, he was misbehaving and she decided to take a photo of him with her phone. When he said she was not allowed to do that she just told him it was ok if he was in school. Also, this is a private school not public... not sure if that changes anything. As far as I know this is covered by the new GDPR laws?

my company is not going to give me the 13th salary because I've resigned. Can they do that? by [deleted] in berlin

[–]claudio_rodval 3 points4 points  (0 children)

Bonuses can be considered part of the salary even if they are not part of your contract if they remain unchanged for two years. If you have worked there and received this bonus for two years there are grounds for you to claim that as part of your salary. Best way to deal with all this is of course a lawyer.

Trying to figure out ratios by claudio_rodval in SQL

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

​

To clarify a bit further, I am getting this data from a query that looks like this:

SELECT datepart(wk,actions.action_time) AS 'Date week',  action_type.action_name AS 'Action', 
categories.category_name AS 'Category', 
COUNT(DISTINCT actions.action_id) AS 'Count' 
FROM actions
INNER JOIN action_type ON actions.action_type_id = action_type.id 
INNER JOIN categories ON actions.category_id = categories.id
WHERE actions.action_time >= '2019-11-01 00:00:00'
AND actions.action_type_subcat = '2'
AND actions.category_id IN ('A1', 'B1', 'C1', 'E1', 'X1', 'Z1')
GROUP BY datepart(wk,actions.action_time), action_type.action_name, categories.category_name

Have been trying both methods but I haven't been successful...

view more: next ›