Okay, I think I get it. Thanks, Chris!

So I would have an Ingredient table (IngredientKey, IngredientSK, IngredientName, Category, UnitPrice, ActiveDate) and then use FILTER() and/or TOPN() to get the most...

SELECT Location_ID, Location, SUM(TotalRate)
FROM <tableName>
GROUP BY Location_ID, Location;

Sorry, missed the n0t-so-fine print.

Not a clue about PostGRES. =(

I'm pretty sure this is what you want. First, create the Supplier table with a primary key, and then reference that in the constraints of the Product table. (it's a...

What's the best way to segregate the SSRS stored procedures from the rest, put them in their own schema, and then grant users execute on the schema? (and SSRS devs...

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...