CODEWITHSUNDEEP
sql-servert-sqlazure-sql-databaseaggregate
David Pfeffer
David Pfeffer

Reputation: 39833

Create a user-defined aggregate without SQL CLR

I am planning on deploying a database to SQL Azure, so I cannot use the SQL CLR. However, I have a need to create an aggregate function -- in my case, I need to STUnion a bunch of Geography objects together. (Azure is expected to support Spatial by June.)

Is there another way to accomplish this, without making use of the CLR, in a query? Or do I have to create a UDF that will take a table as a parameter and return the aggregate?

Upvotes: 1

Views: 937

Answers (2)

influent
influent

Reputation: 1377

Geography is supported in Azure SQL now.

https://msdn.microsoft.com/en-us/library/cc280766.aspx

Upvotes: 0

David Pfeffer
David Pfeffer

Reputation: 39833

You can't do it.

Upvotes: 1

Related Questions