Generating SQL Geometry on the Fly in View or Query Layer

Discussion created by mkoneya on Nov 22, 2013
Latest reply on Nov 23, 2013 by mboeringa2010
I was watching an ESRI video called "Web Enabling Databases with ArcGIS for Server" and I thought I heard them say that SQL Geomety could be created on the fly in a view or in ESRI terms with a Query Layer.

I have a couple of SQL tables that have LAT/LONG and I would like to used this information to create SQL geometry for each row rather than creating an event theme from the LAT/LONG values.      Due to restrictions on the database table,   I am not able to add a Geomtry field to the table itself so I thought I would try to do it via a view/query layer and bring it into ArcMap that way.

I have not been able to find any examples of doing this.    

Let me know if this is possible and more importantly,  if there are some examples of doing so.