Stored procedure to write data from front end screen with master child relationship with variable number of records.
Posted on 2012-03-25
I have a situation where I have to write an insert stored procedure. In this situation one client can have multiple entities and each entity can have multiple sections and each section can have three visibility levels (say 0,1 or 2); Now all these tables are linked with master child relationship. Now from the front end what should be the format to pass this information to stored procedure and how stored procedure should write these values to the tables?
Should I build a big string at the front end and then pass it to stored procedure where I should parse it into individual records and then insert into tables starting from top level master table to last child table!!!!
Can you please suggest possible solutions to this problem? Your comments and suggestions are appreciated.