THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

A T-SQL Tip: Working calculations

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at:

Published Tuesday, December 13, 2011 11:46 AM by Rob Farley



mordechai danielov said:

nice article. I always like to say that nothing we do as DBAs is really a rocket science but requires thinking none-the-less.

December 13, 2011 3:29 AM

Matt Taylor said:

Nice article Rob but I think it would resonate with more people had you used David Beckham, Ryan Giggs, Cristiano Ronaldo and Wayne Rooney ;)

December 13, 2011 3:58 AM

Allen White said:

T-SQL Tuesday #25 fell on the same day I brought my mother home from a 3-day emergency trip to the hospital.

December 17, 2011 4:22 PM

Rob Farley said:

In my last post, I showed a technique for dealing with working columns when writing T-SQL. The idea was

January 9, 2012 7:06 PM

Andy P said:

Thanks for the great post!  I enjoyed the way you built it up from previous versions leaving the reader to see each building block.  It's how I try to do things at work too so it's nice for me to confirm I'm on the right track!

Thanks again


January 11, 2012 4:12 PM

Dave said:

This is a fantastic article! Thank you! However, do you have an example for when dealing with an existing table and some of the column values being calculated contain either NULL or '' ?

September 5, 2013 12:30 PM
Anonymous comments are disabled

This Blog



No tags have been created or used yet.


News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG


Privacy Statement