Date: January 8th, 2005

TheServerSide.NET - Heirarchical Queries in SQL Server 2005

8 January, 2005 (16:49) | SQL Server | No comments

Hmmm someone had a little spelling problem at The ServerSide
Nonetheless, here is what was discussed in Dan Sullivans article:
In summary a CTE can be used to implement a hierarchical query. The SELECT statement before the UNION ALL is executed first and just once. The SELECT statement after the UNION ALL is executed […]

Get the number of days between two DateTimes

8 January, 2005 (16:39) | .NET Code Related | No comments

Calculate the number of days between two dates seems really simple, but there are some exceptions. The simplest idea is to substract two DateTime and get the number of days in the resulting TimeSpan. The method doesn’t work when the two dates are set with different year or the number of hour are less than […]

This SOA hype is getting out of hand

8 January, 2005 (06:38) | .NET | 3 comments

Frans opened a can of worms. Although I have to say that I’ve been pretty much expressing similar views - just not as nicely defined.
Yes there is SOA and yes in time it maybe something useful, but for the moment it is definetly being treated similar to the time whn the .NET moniker was […]