i have done it in other way

i checked UPDATE RULE to CASCADE in relationships in MASTER TABLE

by CASCADE property set.. when we change primary key in MASTER TABLE all...

ChrisM@Work (8/23/2016)

---

You have two rows in each table where Risk_01_Id_Num = '201600015'. Your result set with four rows is expected behaviour. If you wish to limit the result set to...

like the generated .bak files have 7-8 digits randomly generated at the end of name before the .bak 😛

Luis Cazares (8/1/2016)

---

To do what you're asking for, you need to split the values and store them in individual rows. Of course, you can split them and join them again...

Eirikur Eiriksson (8/1/2016)

---

Quick question, can you post the DDL (create table) for the tables, sample data as an insert statement and the expected result set. This problem is trivial but...