Hi, thanks for Your reply.

View  dbo.view_person_count_substr_attrib_2 was not documented.

It also relies on another underlying source.

The whole setup works but it’s very slow and not efficient code.

If you have any suggestions...

Hi,

Thanks for your time. I'll check that out.

Hi,

Thanks for your time helping me out.

I add a trigger to my main tabel  'REJ' thanks for Your suggestion.

------------------------------------------------------------

CREATE TRIGGER REJ_Trigger1

ON dbo.REJ

FOR INSERT

AS

DECLARE @NumberID Int

SET @NumberID = @@IDENTITY

Insert into RSP_PRSNS_details(RSP_PRSNS_details_REJ_ID)...