Awesome thanks! I'll be linking the test scripts in as demo queries at some point over the next couple of days - having fun with the GitHub API.
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.