aggregate for strings

Ideally Sum(stringcolumn,separator) so Sum(MyColumn,':')

On the CLR:

When 05 was first released we thought that the CLR integration would be one of the best features in the product. However, once we actually tried to use it we realized that on average it was doubling the development time over T-SQL procedures/functions. The problem is that building a function in T-SQL is really easy, just load up management studio, edit the template, save and test. On the other hand building a CLR function requires at least a couple more steps if the developer has VS Pro and a lot more if they have VS Standard. This add's cost and time. This was semi alleviated by Neil's project which improved the entire CLR development experience. What needs to happen is that management studio needs to support CLR function development, with a simple one click save/deploy feature, even if it lacks full VS code functions. Likewise at the very least VS should support CLR function development directly off of the server/database explorer.

Edit: At the very least if SQL doesn't support that aggregate then RS should have one like that. Also how close are we to seeing the next CTP drop? I installed the July one on VPC then deleted it and made a new VPC to test another project. Now, I kinda want to reinstall it but I'm hesitating to because I figure that we will see a new CTP drop any day.

akula at 2007-10-3 >

Thanks you have been very helpful. We ended up using a CLR aggregate to solve our string problem. Just out of curiosity will we be able to use linq in the 08 CLR?

akula at 2007-10-3 >