I have a series of points and I wish to create lines in a geography column
from them. I can see how to create a point by supplying the lat/long
co-ordinates, but there doesn't seem to be an equivalent for creating lines.
Of course, there is
geography::STLineFromText('LINESTRING(0 0, 10 10)', 4326)
for example, but this is quite cumbersome, and in its simplest form requires
literals to be supplied. And anyway, I have my point data in two geography
columns, so intuitively I would expect to be able to write something like
geography::STLineFromPoints(point1, point2, 4326)
Can anyone direct me to an elegant technique for doing this, ideally without
resorting to strings and parsing?
TIA
Charles
Replies