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