Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

<br><br>As you've gathered, you can add a literal value to the list of SELECTed fields and it gets treated as any other column.<br><br>My apology was based on the fact that I have lots of Oracle ...