Archive for category SQL

SQL CASE statements and Data Types

Synopsis: All return values from a T-SQL CASE statement must be of the same Data Type. …He thought the request was simple.  “Before you leave [for the weekend], can you make one tiny change…it shouldn’t take more than a minute?”  Or, so I heard a Friday past. “Can we sort the results dynamically?”. I wanted […]

, , , , , , ,

Leave a comment

Don’t add hacks, make features!

Synopsis: Use SQL and  a bit (sorry) of bit comparison to create a “Feature Framework” Is there a good way to add what amounts to nothing more than a HACK to your application? Probably not, but there are ways to mitigate the damage. I was recently given the task of modifying a well-designed client-server application […]

, , ,

Leave a comment