Database Challenges

A Tally Table (also known as Number Table) is an essential tool that every database administrator like to have in their databases. Such a table helps to solve a number of TSQL problems in a SET based manner. Jeff Moden provided a very interesting script which not only gives you a 1 million row tally table, but also demonstrates how to write good TSQL code.