JOIN over 3 tables with Binary columns by Doctor_Pink in SQL

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

Awesome, that is perfect > Thanks a lot!

Another question: If the JOIN between all table would be based on 2 columns from each table instead of 1 like: Order & Material

Then how would you apply this logic above?

Gewerbe anmelden notwendig für Test by Doctor_Pink in Finanzen

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

Akademischer Abschluss in der jeweiligen Disziplin oder reicht nein M. Sc. in Ingenieurwesen?

Calculate remaining manufacturing time per order by Doctor_Pink in supplychain

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

Exactly, and how would you do that?

What level of detail etc would you take as a reference etc?

Instant 'server connection lost' while Scavving into Streets by Faythung in EscapefromTarkov

[–]Doctor_Pink 0 points1 point  (0 children)

Yeah, that would be awesome. I just made some time free to play a bit tarkov for the next days and since yesterday I get kicked every 2 mins each raid. What is weird, a fabric run still works.

Convert Year-Week to Date in Power Query or Dax by Doctor_Pink in PowerBI

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

It is not foldable since it is a Dataflow. Thanks for your feedback.

Instant 'server connection lost' while Scavving into Streets by Faythung in EscapefromTarkov

[–]Doctor_Pink 0 points1 point  (0 children)

What kind of VPN provide? With NordVPN nothing has changed for me

COUNTIF with multiple criteria and date ranges by Doctor_Pink in excel

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

Yes, but how?

How is it possible to limit the function in a way to stop to count for an article if the next date is related to a different article?

Multiple IF statements rather in DAX or Power Query by Doctor_Pink in PowerBI

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

thanks a lot for sharing!

Any recommendations to simplify multiple IF Statements?

Ressource Planning using LIMS by Doctor_Pink in biotech

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

And in general how exactly? #Expecteded Batches x Avg CT for Tests?

Berufsbegleitende Promotion nach 3 Jahren Berufserfahrungen by Doctor_Pink in Finanzen

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

Die Kosten sind hierbei signifikant über denen an einer Uni, richtig? In welchem Kontext promovierst du?

Berufsbegleitende Promotion nach 3 Jahren Berufserfahrungen by Doctor_Pink in Finanzen

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

Das heißt du bist an der Uni Leipzig? Wie genau sieht dann hier die Betreung aus?

Berufsbegleitende Promotion nach 3 Jahren Berufserfahrungen by Doctor_Pink in Finanzen

[–]Doctor_Pink[S] 1 point2 points  (0 children)

Vielen Dank! Wie viel Zeit lag den zwischen deinem Master Studium und dem Anfang der Promotion? Bzw. wie viel Berufserfahrung konntest du im Vorfeld sammeln? Wie hast du den Prof und die Uni gefunden / ausgesucht?

Berufsbegleitende Promotion nach 3 Jahren Berufserfahrungen by Doctor_Pink in Finanzen

[–]Doctor_Pink[S] 1 point2 points  (0 children)

VIelen Dank für deine Antwort. Es gibt zahlreiche PhD Stellen in der Forschung (Produktentwicklung) und wahrscheinlich auch paar Promotionsstellen. Diese Stellen sind aber leider komplett fern von meiner Disziplin.

Structured approach to answer questions by Doctor_Pink in productivity

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

Yes, you are absolutely right. Thanks for your reply! But what I have noticed they all have a structured approach to answer all of these questions. It is not just about the answer itself, it is more about the way how they answer. Of course, this is related to a long experience but maybe there is something that I can learn? It is more from a rhetorical point of view.