I have to insert data in Table1 (which i can). After that I must insert data into Table2 using ID of last entry in Table1 as a parameter in my stored procedure. Don't know how to set the value of parameter to that Table1.ID and use it after.
I have some code but don't want to mess up here. What is the best way to do this and should it be done all in one stored procedure or not? ÃÂ
View Complete Post