I agree. Thanks again for your post, implementing this aggregate function will save myself more work than you could possibly know.

For those stuck at 8000 bytes setting for MaxByteSize, SQL Server 2008 has bumped this amount to 2 GB! Just set MaxByteSize = -1. Only challenge to this, is you...

We recently went through an exercise on automating Excel, and it is what I would consider to be the "worst case scenario". We had a few hundred excel documents in...

I've been geocoding assets using a variety of engines and I've been surprised that yahoo's engine has been more accurate than Google's geocoding service. Has anyone else noticed this?

Here's what you need for google maps:

using System;

using System.IO;

using System.Net;

using System.Xml;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.Globalization;

namespace Geocoders

{

public partial class GoogleGeocoder

{

...

I'd love to see the Package feature in SQL Server 2005. It's a nice OO approach to developing stored procedures.