title: SQL server stored procedure cascade insert three tables
body: <p>I am running on my own project. Earlier I was using MS access database but now its not enough to handle such a huge data. </p>
  
  <p>My problem is I am using stored procedures and I need some advice. </p>
  
  <p>I try cascade insert for 3 tables. first table only keeps agreement numbers, second table addresses for agreement and last table stuff for those addresses. single agreement can have many addresses and all those addresses can have many stuff. </p>
  
  <p>Scope_identity,output etc. works well but when i have only single record for all tables. </p>
  
  <p>I hope I could explain system. Simple help would be nice. 
  Thanks</p>