Refactoring Databases - Evolutionary Database Design

Introduce Variable

Put the result of the expression, or parts of the expression, in a temporary variable with a name that explains the purpose.



More on refactoring.com

For more information see page 287 of Database Refactoring