I'm using a master-detail structure for my data modeling. To make inserting data into two tables within one query possible, I'm using CTE. This works perfectly for my first query but somehow not for the second one. Does anyone have a clue what the underlying issue could be? The SQL triggers for all three tables are exactly the same.
WORKING entities + company details:
NOT WORKING entities + person details:
This is my output for the defect query:
