Is there a difference in control type/date format (data type) between the ones that do and don't work?

No, they use the same domain. The only difference in the functionailty I can find is in the insert trigger, but the code itself does not seem  to be a problem (to me):

       set pc.end_date = dateadd(day, -1, i.start_date)

Hi Hugo,

If the end_date is set to be equal to one day before the start_date, that could be preventing the insert in some way. Is there a check that enforces end_date to be bigger that start_date?

Hi @Hugo Nienhuis,

Can you please respond to Mark his latest question? Thanks in advance!

We have a check that enforces this behaviour. To make a long story short, we (have) experience(d) a lot of difficulties when importing data into this tabel. There are both triggers and handlers on the table, as well as quite some lay/def code for enforcing several of these rules. This makes importing data quite vulnerable to mistakes.

I have been thinking to create a separate importing-table to easily import the data, and creating a task to test and correctly insert that data. That will give me more control of the import process. If anyone has another possible solution to this I would be thankful. If not, you can close this subject.

Allright Hugo, we can keep this topic open for a while to see if someone comes up with an alternative solution. If this is not the case I will make sure we'll close this topic after a while.