Any time I see something like "Coding required as Subquery NOT as Join" it tells me for sure this is homework.
You'll find that few on this forum are willing to do your homework for you.
However if you make a fair attempt at solving the problem, we're likely to try to help you get it right.
Suggest you post some table DDL and sample test data in a consumable form, along with your first attempt.
+1 to all that. Well said on all fronts.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs