try catch, raiserror and throw get first parent with a value Task2 TUAN 8_BTTL SQL for beginners( defined with errors while enforcing constraints) Update using a temp table Veterinary 1 BRYAN_BD1 SUPPLIER Insert multiple parent-child records