I have two tables i need to insert data into using a stored procedure. One is main table and other is its detail table.There would only be single row in main table
The problem is the count of rows to insert into the detail can vary. Sometimes there won't be any and in other occasions there would be like 10. I have to include the insert into both tables in a single SP. How can i achieve this? Should I pass the total rows as a single string and its count as an int variable and decode it in sp?
Help T.Y. (I am using vb6)