Got some details? Like the parameter values you're trying to pass, the parameter definition, the stored procedure text, the related column types and sizes... you know, something so we can...

Setup:

USE tempdb;
GO

drop table if exists #procvalues;
drop table if exists #deptvalues;

create table #Procvalues
(
PatID varchar(10)
,AcctID varchar(10)
,ProcDate date
);

create table #Deptvalues (
PatID varchar(10)
,DeptDate date
,Department varchar(10)
);
GO

Insert into #Procvalues
values
('1','28304','2021-01-21')
,('2','34893','2021-01-17')
,('2','33845','2021-01-19')
,('3','39483','2021-01-13')
,('4','39056','2021-01-25')
,('5','29112','2021-01-09');

Insert into #Deptvalues
values
('1','2021-01-21', 'Dept1')
,('2','2021-01-15', 'Dept3')
,('2','2021-01-18',...

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?