views/stored procedures to hide columns from some users --Sure, you wouldn't let just anyone see a patient's Social Security Number, for example. If you did, and someone misused it, that...

No problem. Just looking for general directions. I think I can figure the rest out myself. (Well, I hope I can!)

bcp out

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);