GOOGOOGOO is my batch separator

SSMS: From Query menu select Query Options, Batch separator

Do whatever you want with the software.

Don't blame me: THIS SOFTWARE COMES WITH NO WARRANTIES, USE AT YOUR OWN RISK

Do give me credit for my work

I have done some performance tests and the results are thus: proposed solution ~ 10 seconds (conversion and UnionAggregate), one of IBG solution 3 seconds.

• This reply was modified 4 years, 8 months ago by  Bogdan SAHLEAN.

Thanks. The best thing is that sql spatial extensions, are part of sql standard.

• This reply was modified 4 years, 9 months ago by  Bogdan SAHLEAN.

First, thank you for your interest in my article. I have done performance testing just for this article

https://www.sqlservercentral.com/articles/collections

comparing proposed solution vs table vars using single thread tests and also...