Remove a dash in multiple records with TSQL

Just a self-reference to TSQL code used to clean up multiple records in a table column by removing a dash from the value.

SELECT TOP 10 * FROM table_name WHERE some_logic
SELECT replace(column_name, '-', '') as [New column_name] FROM table_name WHERE some_logic
UPDATE table_name SET column_name = replace(column_name, ‘-’, ”) WHERE some_logic

What and how we learn

From William Glasser on what and how we learn. (via)

  • 10% of what we READ
  • 20% of what we HEAR
  • 30% of what we SEE
  • 50% of what we SEE and HEAR
  • 70% of what is DISCUSSED with OTHERS
  • 80% of what is EXPERIENCED PERSONALLY
  • 95% of what we TEACH TO SOMEONE ELSE

Re: Getting the message in

A message from the 37Signals guys that really resonated with me. They discuss the importance of bringing your message into the organization and mention Apple as a recent example.

Getting the message in is about feeding the culture. It’s about making people proud of the work working on. I think it’s an important lesson for anyone building a team. Getting the message in is as important as getting the message out.

Please excuse the dust

Things have been very quiet around here, mostly because I could not motivate myself to write on an environment that has been stale for a long time. The main intent of this website was always to serve as a playground, well the playground did not change much over the last couple of years and that is just sad.

I have been playing around with a new look and some new features that I have been thinking about for a long time. Things might appear a bit broken over the next few days but I hope this will give me the motivation to put time and effort back into my website.

The visual design is a work in progress and links might break during the transition. I am sure you will survive the chaos. I hope I am taking this site in the right direction.

toasty!

forecast.jpg