I have a table in a database that contains an easting and a northing for broadband relay stations. I am trying to create a view in SQL Server 2008 R2 that I can use in QGIS and I want to create a geometry field on the fly from the easting and northing. An example is Easting 257306 and northing 142708 (stored in separate fields) converted to POINT(257306 142708) as a geometry.
I've used the following code:
geography::STGeomFromText('POINT(' + CONVERT(varchar(20), Easting) + ' ' + CONVERT(varchar(20), Northing) + ')', 27700) AS Geometry
but I get an error that states that the specified SRID must match one of the supported ones in sys.spatial_reference_systems and I've looked and 27700 does not appear in that table.
How do I create this on the fly geometry field in my view?