August 18, 2007In a recent post I wrote about a flexible structure used for storing and retrieving classifications form a database. My example retrieved “entities” for a single classification, and those entities that matched any of that classifications children.
In this entry I want to expand on this approach, and demonstrate how results can be limited to only [...]
Posted in SQL 2005 
No Comments »
August 8, 2007Frequently our team is tasked with creating a way to categorize data. One very common and flexible approach is to create a table which contains a series of parent-child relationships. This hierarchical approach can be extremely flexible and efficient for categorizing multiple levels of content. Here is an example of a table used to store [...]
Posted in SQL 2005 No Comments »
July 17, 2007Today I was tasked with formating a SQL Datetime field as part of a FOR XML query. More often then not, I can get away with formating in the presentation layer and leave all dates in the standard ISO8500. Today I needed a nice looking date to be concatenated within a business name. I stumbled across this approach which [...]
Posted in SQL 2005 No Comments »
