Just a little comment, everyone demonstrates the += compound assignment operator. What some people does not know yet is that SQL Server 2008 supports the following list of compound assignment operators: