This can be implemented using either SQL Spatial Tools support or the native XML functionality along with STAsText() and xml path('').
Environment
None
Activity
Ricardo Stuven
November 10, 2010 at 11:29 PM
Patches are welcome.
David Pfeffer
November 10, 2010 at 9:27 PM
It would be great if at least union aggregate could be supported for SQL08 using the XML PATH hack. I'm using SQL Azure and I'm at Microsoft's whim for when they decide to upgrade us.
Ricardo Stuven
November 10, 2010 at 9:25 PM
The following aggregates will be supported by SQL Server Code-Named "Denali" as static methods on geography and geometry types:
This can be implemented using either SQL Spatial Tools support or the native XML functionality along with STAsText() and xml path('').