topic Re: How to create a view from child version without using the stored procedure method? (SQL) in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837416#M4505 <HTML><HEAD></HEAD><BODY><P>No other workarounds as off&nbsp; now...Stored procedures are the only way</P><P>Similar post:&nbsp;<A href="https://community.esri.com/thread/199281-how-to-create-a-version-view-of-a-specific-version">https://community.esri.com/thread/199281-how-to-create-a-version-view-of-a-specific-version</A>&nbsp;</P></BODY></HTML> Wed, 20 Jun 2018 18:31:04 GMT Asrujit_SenGupta 2018-06-20T18:31:04Z How to create a view from child version without using the stored procedure method? (SQL) https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837414#M4503 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to find a way to create a versioned view of a named version (not default version) in SQL server. The feature class is registered as versioned without the option to move edits to base.</P><P></P><P>In table views within SQL server there are versioned views available from every feature class, but this is the default version. Is it then possible to have a view from the underlying version (child) of default, <STRONG>without</STRONG> using the stored procedures?</P><P></P><P>I have already asked an Esri Inc Analyst, and he told me there is no other way than using stored procedures to create the versioned view of a specific child version. So here i am, asking the Esri community, maybe someone has found a workaround to this same issue?</P><P></P><P>Thank you in advance!</P></BODY></HTML> Thu, 05 Apr 2018 08:43:59 GMT https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837414#M4503 MilPARMENTIER 2018-04-05T08:43:59Z Re: How to create a view from child version without using the stored procedure method? (SQL) https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837415#M4504 <HTML><HEAD></HEAD><BODY><P>Did you ever figure this out?&nbsp; I am trying to do the same thing and feel there must be a way.&nbsp;&nbsp;</P></BODY></HTML> Wed, 20 Jun 2018 12:13:08 GMT https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837415#M4504 ShanaLowe 2018-06-20T12:13:08Z Re: How to create a view from child version without using the stored procedure method? (SQL) https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837416#M4505 <HTML><HEAD></HEAD><BODY><P>No other workarounds as off&nbsp; now...Stored procedures are the only way</P><P>Similar post:&nbsp;<A href="https://community.esri.com/thread/199281-how-to-create-a-version-view-of-a-specific-version">https://community.esri.com/thread/199281-how-to-create-a-version-view-of-a-specific-version</A>&nbsp;</P></BODY></HTML> Wed, 20 Jun 2018 18:31:04 GMT https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837416#M4505 Asrujit_SenGupta 2018-06-20T18:31:04Z Re: How to create a view from child version without using the stored procedure method? (SQL) https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837417#M4506 <HTML><HEAD></HEAD><BODY><P>My goal is to write a report that anyone can run at any time that hits a specific version of the data.&nbsp; I have not found a way to do this.&nbsp; Any suggestions?</P><P>Thank you!</P><P>-Shana&nbsp;</P></BODY></HTML> Wed, 20 Jun 2018 19:14:59 GMT https://community.esri.com/t5/geodatabase-questions/how-to-create-a-view-from-child-version-without/m-p/837417#M4506 ShanaLowe 2018-06-20T19:14:59Z