Daily Archives: July 7, 2011

The IF Statement in a T-SQL Query

Posted on July 7, 2011 by way0utwest

I’ve seen quite a few posts from people asking how to do something like this: SELECT a.ID , IF a.MyChar = ‘A’ THEN ‘Success’ ELSE ‘Fail’ FROM MyTable a Of course, that doesn’t work in T-SQL, and you’ll get something … Continue reading →

Posted in Blog | Tagged , | Comments Off on The IF Statement in a T-SQL Query

Measurements

Posted on July 7, 2011 by way0utwest

“If you cannot measure it, you cannot improve it” – Lord Kelvin. That’s a quote that comes from this blog post, talking about ways in which you might measure your performance. Numbers are not the only important thing to measure, and … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Measurements