Provide SQL Server union aggregate support

Description

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:

  • UnionAggregate

  • EnvelopeAggregate

  • CollectionAggregate

  • ConvexHullAggregate

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created June 26, 2010 at 8:02 AM
Updated November 10, 2010 at 11:29 PM
Who's Looking?