topic SQL Query to get all Records from a versioned geodatabase in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41450#M2288 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #343a41; background-color: #ffffff;">Does anybody know the query to get the latest of ALL records in a versioned SDE geodatabase (including records from the add and delete (A&amp;D) tables? I'm specifically looking for SQL Server.</SPAN></P></BODY></HTML> Fri, 25 Nov 2016 05:24:04 GMT BhargavaRam 2016-11-25T05:24:04Z SQL Query to get all Records from a versioned geodatabase https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41450#M2288 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #343a41; background-color: #ffffff;">Does anybody know the query to get the latest of ALL records in a versioned SDE geodatabase (including records from the add and delete (A&amp;D) tables? I'm specifically looking for SQL Server.</SPAN></P></BODY></HTML> Fri, 25 Nov 2016 05:24:04 GMT https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41450#M2288 BhargavaRam 2016-11-25T05:24:04Z Re: SQL Query to get all Records from a versioned geodatabase https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41451#M2289 <HTML><HEAD></HEAD><BODY><P>Instead of querying the Feature Classes or Tables, try to pull the updated data from the Versioned views. Versioned view will show data from the Base\Business Tables and the Delta Tables both, which is what you need.</P></BODY></HTML> Fri, 25 Nov 2016 05:37:03 GMT https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41451#M2289 Asrujit_SenGupta 2016-11-25T05:37:03Z Re: SQL Query to get all Records from a versioned geodatabase https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41452#M2290 <HTML><HEAD></HEAD><BODY><P>Thanks Gupta for quick response.</P><P></P><P>Versioned views holds the data only after the versions are &nbsp;"reconcile &amp; post" to default.</P><P>Is there any query/method to get the all the records before i post it to default? &nbsp;</P></BODY></HTML> Fri, 25 Nov 2016 06:02:50 GMT https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41452#M2290 BhargavaRam 2016-11-25T06:02:50Z Re: SQL Query to get all Records from a versioned geodatabase https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41453#M2291 <HTML><HEAD></HEAD><BODY><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/read-sqlserver-versioned-data-with-sql.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/read-sqlserver-versioned-data-with-sql.htm">Read versioned data in SQL Server using versioned views—Help | ArcGIS for Desktop</A>&nbsp;</P><P></P><P>This link should give you the idea.</P></BODY></HTML> Fri, 25 Nov 2016 06:07:55 GMT https://community.esri.com/t5/data-management-questions/sql-query-to-get-all-records-from-a-versioned/m-p/41453#M2291 Asrujit_SenGupta 2016-11-25T06:07:55Z