One of my examples that I use to demonstrate various statements.

/* Demonstration of temporary table destruction, creation and population;

* table modification; conditional updating; and windowing functions

*/

IF OBJECT_ID('tempdb.dbo.#ranks')...