Subscribe to this blog
New York City .NET
The author of the NYCdotNet blog is a VB.NET and SQL server developer living and working in New York City. The author seeks to promote clean, readable, efficient code in both VB and SQL from design to development, deployment, and application maintenance.
Archives: October 2011
Save a step: Using Computed Columns in a Table Variable (or Temp Table)
One of the databases that I support reports all money values in both the local currency and US Dollars. Very often we will do all of our calculations in a table variable using the local currency and then calculate USD equivalents at the very end.
With this methodology, adding a… Read more
1 comments, 2,088 reads
Posted in New York City .NET on 28 October 2011