The pictures don't help a whole lot. Sounds like all you need is a matrix visual, and regions on one axis, months on the other, and SUM([Quantity]) at the intersection.

Use LAG() to do that.

What reporting tool are you using? How's your data structured?

If you're querying against a data warehouse, I'd probably use Excel, because it provides a relatively simple UI. you can use...

I'd do this a bit differently. You need at least two tables. One for Customer, and the one you have above. (Preferably one more, that has details about what MatchTypeID...

Thanks Martin!, I'll have a look.

And I guess I have to dust off Ralph Kimball's book.

STRING_AGG() is your friend

Maybe

SELECT SubmissionGUID, QuoteStatus
FROM #Subs
WHERE SubmissionGUID NOT IN (SELECT SubmissionGUID
FROM #Subs
WHERE QuoteStatus = 1);

keep only the previous day's data and replace the rest of its data with the subsequent current day's data.

DELETE

FROM MyTable

WHERE [DateColumn]<GETDATE()-1

INSERT INTO MyTable

SELECT ...

FROM OtherTable

WHERE [DateColumn] = GETDATE()

?

Maybe do the P*Q for the lowest priced fruits, sort that way, then do a running total. Filter for running total less than your threshold?

Why are you recreating tables all...

This is not an answer factory. Crack open a textbook if need be and actually learn something for yourself. If you want answers without doing any work, open your wallet.

No...

I'd see if you can't do it with PowerShell.  Rob Sewell & Chrissy LeMaire may well have that in their dbatools library. I'd look at that first, or ask them...

Phil,

If you want, I can DM you a few receipts in PDF form (I'll have to change the extension, but ...), and you can if you wish, if only for...

Phil,

thanks for looking at it. The good thing is that since it's a bakery, he only buys a small number of different ingredients, so entering them by hand won't be...

Something like this should work:

SELECT g.ID,
StartTime = MAX(IIF(rn=1,Game_time,null)),
EndTime = MAX(IIF(rn=2,Game_time,null))
FROM
(SELECT Game_time, ID, ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Game_Time) AS rn
FROM Game) g
GROUP BY g.ID

Wait, I have to solve a problem??? <g>

He's not a computer guy at all. And most of his computer-related work he does on his iPad. So unless I do something...