Finding a use for the SQL CLR
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.
Comments
Comment preview