Not convinced AdventureWorks is a good representation of what your real situation is; In your CTE you are grouping by ProductId and then grouping again in your query, so you are...

Simple one to start the week, thanks Evgeny.

I agree with everything that has been said, and not sure why you would want a trigger. That said this may be of some assistance although I am fairly certain Jeff...

To be helpful, you seem to want to update the orders table. I doubt there is a column ShippedToMexico, more likely ShippedTo, so that is the column you wish to...

To be controversial, Don:t do either with the caveat of 'if it contains data pertaining to an individual or an identifiable individual', if this is the case I would script...

There is, or at least was, a free tool from Microsoft that can help in discovering all SQL installations, have not used it in years but it is used in...

Could you post DDL and some sample data, this may help.others to help you.

Good question, thanks Steve and +1 on the RH