Hi,

Not sure how you get 4 tables since there is only one SELECT. You maybe getting the "messages" (usually the row affected count) from the INSERTs (unless your spMoldingBarcodeCreate actually returns recordset). Try putting "SET NOCOUNT ON" at the beginning of your SP which will suppress the affected count message. Then your SP will only return one recordset and you don't have to iterate through DataTables. Also, post your current code in VB that you have so that we can check it out.