[FEATURE] OUTPUT needed so i can record the guids of new records to create relationships

[magiva]

Is your feature request related to a problem? Please describe.
during an update or insert i want to get the record id of each new row so i can then update the source data rows, essentially creating a relationship to the new records.

Describe the solution you'd like
INSERT INTO target_table (name, address)
OUTPUT inserted.row_guid, source_table.source_guid

Describe alternatives you've considered
i used creation date to see the records id created and then used that data to manually align (it was late :))

Additional context
Add any other context or screenshots about the feature request here.

[MarkMpn]

Thanks for the suggestion!

You can get the ID of newly inserted records using @@IDENTITY which might get you what you need, e.g.

INSERT INTO account (name) VALUES ('New Account')

INSERT INTO contact (firstname, lastname, parentcustomerid) VALUES ('Mark', 'Carrington', @@IDENTITY)

[magiva]

its good idea but i thought this is only for 1 record as it returns only the last insert.
wouldnt work for multiple inserts i believe. happy to be wrong though :)
i think my better option would be to create a temp table in dataverse to handle it

[MarkMpn]

Indeed, using OUTPUT would be a good enhancement but flagging @@IDENTITY as a possible workaround for now when you are working with single records.

[magiva]

appreciate the response

…

On Wed, 4 Dec 2024 at 09:48, Mark Carrington ***@***.***> wrote: Indeed, using OUTPUT would be a good enhancement but flagging @@IDENTITY as a possible workaround for now when you are working with single records. — Reply to this email directly, view it on GitHub <#597 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABZMQZON7DVLVH7EBQI5I3D2D26WBAVCNFSM6AAAAABS57DPI2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKMJWGU3TONRZGM> . You are receiving this because you authored the thread.Message ID: ***@***.***>