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

Welcome to SSC.  I think your question needs some help.  One thing that's a challenge when you first start out is knowing how to ask a question that will get...

just an FYI.

the best way to get help here is to post the SQL statements to recreate your problem in a code window inside you post. People will be super...

In case you feel like doing some reading.... You're trying to find the size of each island. here's an article on it: https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/introduction-to-gaps-and-islands-analysis/