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), APS/PDW trainer 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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



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

Leave a Comment


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