In other words, a running total of  Open + Created + Won + Lost

You could calculate them individually and then add... or...

ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW?? (using a...

Don't you optimize workloads and not individual queries? Some queries may get slower if you change indexing, but on the whole, the workload efficiency will increase. I doubt that's something...

Oh, sorry. Silly me! So I just modify the step where it writes the one row ...

 ' Display last table's content.
    ...

• This reply was modified 6 months, 3 weeks ago by pietlinden.

Why would I need enterprise grade for a one man show? For something he'd run every few weeks?  I'm not processing 100K files an hour.

If you can point out where...

FWIW, I got one way to work... I used Abscess and Excel and a linked table to SQL Server. That way I can just call .RefreshAll() in Excel so that...

Okay, I'm an idiot. It's super simple.

Take the total value of the new inventory

((Unit Price / Unit Weight * Qty Purchased) + (Per Kg Price * Weight On Hand) )...

(You could absolutely cheat and create a hyperlink or a button in your Access front end that opens the SSRS portal, and then you wouldn't really need Access reports at...

I've been looking at a bunch of them. There are several libraries that read/parse PDFs. Guess I'll dig into that.

I asked them at Costco if they could do something crazy and send me the file as a spreadsheet and not a PDF, but nope. I guess they're super proud...

I don't think I can remove Excel, because for some reason, PowerQuery *in Excel* can read/parse tables in a PDF, but the PowerQuery source in SSIS can't. (???!!!!!) The weird...

• This reply was modified 7 months, 3 weeks ago by pietlinden.

Right now the tables are kind of wrong, but this is a rough outline:

CREATE TABLE Ingredient (
IngredientID INT IDENTITY(1,1) NOT NULL,
IngredientName VARCHAR(25) NOT NULL,
IngredientWeightKg DECIMAL(5,2),
VolumeL DECIMAL(5,2)
CONSTRAINT pkIngredient...

Got data? What if you use OUTER/CROSS APPLY to retrieve the top N records?

Prove it doesn't work. Provide some data.

Got  sample data? I wanna see if you're right.

• This reply was modified 8 months ago by pietlinden.
• This reply was modified 8 months ago by pietlinden.

Can I cheat and do this in PowerQuery?

What if you change MAXERRORS = 0 to MAXERRORS = 1 (or whatever your upper limit is)