I have an ESRI Feature Class that is updated using a Collector Field Application. I want to run a nightly process that finds all the new records and assign a unique ID Value that is not ObjectID or GlobalID. My Plan was to test the Feature Class for new records and use a SQL Server Sequence(Using SQL Executor) to assign a Unique ID. I have it just about setup but am having a problem adding the Result Values from the Sequence to the Feature Class. I am using SELECT NEXT VALUE FOR TESTSequence_seq AS FC_SEQUENCE. How do i combine the Seqence values and the Feature Class?
