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 5 months 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 5 months, 1 weeks ago by pietlinden.
• This reply was modified 5 months, 1 weeks 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)

Oh, and then to import that result into SQL Server, you have to use the 64-bit Import Export Wizard. Then the 64-bit Excel stuff would be visible and work!  (Imagine...

• This reply was modified 5 months, 1 weeks ago by pietlinden.

How do you know from the data when a DBAS event ends? Just prior to the next DBAS event?

For someone with as much experience here as you seem to have, where's the explanation of what you're trying to do? You know, in plain English.

For someone with as much experience here as you seem to have, where's the explanation of what you're trying to do? You know, in plain English.

Try/Catch blocks?

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver16