Normally you use report parameters, kinda like you do in Abscess. Normally, you just include the parameters in your stored procedure...

CREATE PROC ReportSP 
    @StartDate DATE, 
 ...

Failed to find real location of C:\Program Files\Python310\python.exe

What's the path to the Python executable on your computer?

one way is to use a Calendar table (which could be overkill) so you know which weeks go together.

DATEPART(week,[date Column])

will give you the week of the year,...

Johan,

Sorry for taking forever to get back to you, but I get it. It was pretty much what I expected. I need to use a cursor to loop over the...

I think I understand what I did wrong.

Between Purchases and Usage is maybe an "allocation" table, where I allocate one or more "blocks" of ingredient to each "BakeEvent" (just another...

Drew,

Okay, sorry, I'll bash that bit out in a little. I hope.. Just a lot going on right now.

Oh, I think I get it. You're doing a running total of Purchased and subtracting a running total of Used. Easy enough. Where does the UnitPrice come into this? that's...

Drew,

yes, I did. Sorry, just been doing other stuff.  I'll go look at it and add questions to that one. Because I know I'm going to be confused.

Sorry about that!

Thanks,

Pieter

Where is your question? Are you trying to determine if ProcessDate is between StartDate and EndDate?

look up windowing functions. new since 2012 at the latest.

if it's only one or two values, then I probably wouldn't use a lookup table. It would be simpler to just use a CASE statement, but if there are lots...

thanks Martin. I'll probably just get a used copy. If I don't like it, I'm only out like $10.

Where's your question?

Are you asking if there's a standard format for "AML" files? Are they XML? Is there an example of one somewhere?

Martin,

have you read Joe Caserta's book on ETL (from the Kimball collection)? ISBN: 978-0764567575

I'm just trying to get my head around doing the ETL etc and building proper dimensional models...

Okay, I got the "explode Starter ingredients" bit working, so now it's getting easier!

CREATE VIEW [dbo].[vwBaseIngredientRecipe]
AS
WITH cteRecipe(RecipeID, RecipeName, IngredientID, IngredientName, RecipeWeight)
AS (
SELECT 
r.RecipeID
,r.[Recipe Name]
,i.IngredientID
,i.IngredientName
,ExpandedRI.RecipeIngredientWeight

FROM
/* non-Starter ingredients */
(SELECT...