I’ve got a process that inserts data into a sql server using the Execute SQL Statement.
I use the Scope_Identity() to get the index value for subsequent inserts to other tables.
Is there a way to get that value back into the process?
I need to know the value several steps later.