You can expect:
This is a medium intensity post (you should not get a migraine, but I make no promises).
I Expect (that you have the following experience):
T-SQL Stored Proc experience
Windowed Function experience
Basic Join understanding
Row Number Generation
There are a number of ways to generate row numbers in T-SQL. One way is to create a temp table with an identity column and do inserts into that table. Typically you do it in a while loop with a counter. I've used this method in the past and it...