I am trying to import point data from a MSSQL database to QGIS. Is it possible to declare some SQL to create the geometry (X,Y) on the fly? The MSSQL table importer does have an SQL column on the side, but i'm not sure of the correct syntax to get this to work or if its even possible?
('POINT('+convert(nvarchar(24),convert(decimal(18,4), p.y)) + ' ' + convert(nvarchar(24),convert(decimal(18,4), p.x))+')') as geomtext