User-Defined Types and Aggregates
I know we tried to cover too much information today. I had to speak faster than I would have liked, and pass over code that may have been interesting or valuable to some in the audience. I apologize and hope to add some additional information here attempt to further explain.
First here is the Sample code you saw today. http://www.neudesic.com/uploads/Steve_Muise/04_UDT-Agg.zip
In the zip file is the T-SQL code, the C# and VB.NET code.
I will post the sample code that shows the Serialization for the Format.UserDefined, later on this afternoon.
Finally there was a question about Indexing on a UDT. I tested real quick and confirmed you can create an Index on a UDT field. I will do some more research and make sure there aren't any gotcha's we need to look out for.
See you in 2 weeks
Steve