#1 and #4. Choose wisely! I chose poorly.

Good Question. Maybe specify database version though as that only became valid in 2012.

Not crazy about this question as it is misleading. LEAD / LAG are not generally used to retrieve "all rows before this one" without doing some additional work to...

Didn't know you could do a sp_help on a temp table. Thanks for the question!

Assuming the original table has two records in it is a big thing here too. The answer is notably different when you only start with one record. I...