THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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: http://blogs.lobsterpot.com.au/2011/12/13/a-t-sql-tip-working-calculations/

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

Comments

 

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

Andy

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

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement