ok i 've changed the statement that suggested from u... when im trying to insert values then i got new error as u said..

subquery returned more than 1 value....

there has no data in my table after i've inserted into table v_OrganizationDetailType. Let me explain again. I've created instead of insert for both table of OrganizationType table anf...

any suggestion??

i have changed using ur recommendation... but when im trying to insert values into table v_OrganizationDetailType... its really done... but when i want to select to view data that i...

i've changed the trigger command that u given to me buat when i was insert the value, i got this message Msg 512, Level 16, State 1, Procedure trg_InsertOrganization, Line...