i need single stored Procedure using two insertion table, I want to know how to use multiple insertion queries in a single stored procedure. I am using Sql server 2005 as my back end. In my application form, i have put one control drop down list. When i clicked on the list, it will popup some names eg Sony,dell etc. So if i clicking one name means its information has to be stored into individual table named Sony, Dell so on. Kindly i request you to give me procedure to make it possible. It will be very thanks to you.