Month: August 2004

datetime comparisons in T-SQL aren’t always a walk in the park. One of the most annoying things that someone would need to overcoming is filtering solely on the year, month, and day component of a datetime field. This is further complicated by how .NET initializes a DateTime object. When a DateTime object is instantiated without… Continue reading Compare datetime Fields By Year Month and Day

The ability to page in SQL Server is one of those things that everyone wants, but can’t quite seem to get from Microsoft. Many ideas have been posted, each claiming to be _the_ way to do it. In the spirit of mine is better than yours, I’ve implemented my own paging scheme. A feature that… Continue reading Return a Subset of Data From a Table

5. Dan Black Belt Your skills as a both a teacher and practicioner of MT-Do are now at a level few people will reach. You are most likely a worthy contributor in spreading the noble practice of MT-Do to others. Take the MT-Do test

This notation: if ( null != route) really pisses me off.