Finding a use for the SQL CLR

time to read 1 min | 104 words

There has been talk about whatever the SQL CLR feature in SQL Server 2005 is a Good Thing TM  or not. I am using it in my current project, and it certainly saved quite a bit of code to do so.

The issue is date processing, which is something that SQL Server seems to be lousy at. There isn't an easy way to find the last day of a given month, or to do things on all the days up to the last day, etc. This is where a short detour to C# can save hours of agony and lots of ugly code.