Dug into SQL more than I normally would need to. Had to do some cleanup work and needed to be able to generate some reports of the data that got changed. OUTPUT and INTO have made it a lot easier than I remembered it being. This stackoverflow answer was also very helpful in choosing between temp tables or table variables.
Need some examples of good documentation? Check out these examples on github https://github.com/PharkMillups/beautiful-docs