I have tried the SQL CLR sample in MSDN that accomplishes the same thing by using a User-Defined Aggregate function. I think it works great (no issue so far...