How to Scale Geometry Data in SQL Server 2008 r2 ?

Question

question

DharmanDave asked Oct 31, '12

How to Scale Geometry Data in SQL Server 2008 r2 ?

I am having Geometry Data type in two different tables, the scale of co-ordinates is different in both the tables. I need to consolidate the data into a single table with the same scale. What is the best way to do it ?

sql-server-2008-r2 geometry

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-10-31T16:32:43Z

Grant Fritchey answered Oct 31, '12

[Here's a function][1] that should do what you you're looking for. [1]: http://www.spatialdbadvisor.com/sql_server_blog/

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DharmanDave commented · Oct 31, 2012 at 05:29 PM

Thanks Grant ! The Problem with this is : there's an inbuilt tokenizer function required which returns two values. for sql 2008: the tokenizer function provided on the same site is an older version which returns only the token and not the delimiter. for sql 2012 and Denali: the tokenizer is a proper function but the lead() in built function is not there in 2008 R2.

0 ·

question