Think I'm gonna bite the bullet and rebuild with sane field types etc and see what happens. =)

But to answer your question, yes - the goal is to take a...

• This reply was modified 1 year, 6 months ago by pietlinden.

Oh I get it! (duh!)

split the recipe into two parts in the CTE.

Part 1 is all the ingredients, weights for everything except the starter

UNION ALL

(For each ingredient in the Starter,...

Oh I get it! (duh!)

split the recipe into two parts in the CTE.

Part 1 is all the ingredients, weights for everything except the starter

UNION ALL

(For each ingredient in the Starter,...

So does Poolish (a recipe) ALSO have a starter?

No. Poolish / Starter is what the yeast grows in.  Not that it matters that much, but Poolish is 50% flour, 50%...

yeah, you know, the database version of a weeping sore.

No, I didn't. gotta try that.  Okay, seems to be okay now. Thanks for the tip!

(I wonder if they can merge these two posts... Drat!)

I think Jeff is right.  If I can express the two or three "Starter" recipes as input into another recipe, then...

(Yeah, my browser went a bit nuts)

Have you even tried using PowerBI? If that doesn't make you hate Microsoft, nothing will. There are bugs in the software that have been there for like 10 years. My...

You have that many points and you can't be bothered to post some consumable data?

You could join on

LEFT(TableA[column],8) = LEFT(TableB[column],8)

• This reply was modified 1 year, 6 months ago by pietlinden.

What's to understand?

INNER JOIN removes records from the result set where no matching values exist on both sides of the join. So t1.Name and t2.Name will never have null values...

So use LAG() to return the previous day's value or LEAD() to return the next day's value. Well, assuming that gaps are only a single day. But you know what...

Sort of... the answer (well, it's PowerBI and DAX, so of course Marco Russo answered it on YouTube...)

In case anybody is interested, it's here: Managing hierarchical organizations in Power...

Okay, guess I have some reading to do. The basic idea is that any node on the tree can see all his underlings, but nothing above that, and nothing on...

Disclaimer: I'm not a DBA.

But, have you read Gail Shaw's T-SQL Howler about Partitioning? If you haven't read it, you owe it to yourself to do so before doing...

Cast as Decimal?

SELECT CAST(154399.234 AS DECIMAL(17,2));