I have a Stored Proc that works fine from SSMS. In general this is what the Stored Proc looks like:

1. Deletes data in Table A.

2. Inserts data in Table A with an Insert ... Select ...

3. Deletes data in Table B.

4. With a Parameter it Inserts Data in Table B with an Insert ... Select ...



The Data in Table B is from Table A using a Group By. The BO is based on Table B and remains empty when I try to fill it with the following commands:

Dim cmd As New SqlCommand("sp_gborderbyavegoonegotwo")

cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add("@rodeoid", SqlDbType.Int).Value = nrod

Me.FillDataTable(cmd)



nrod is defined as an integer and has the correct value. Of course I don't know if a stored proc can have multiple statements but since it worked in SSMS I thought it would work with a BO and I tried to find the info on the forum but could not. Thank you for any advise you can give me. If you need more info please let me know. TIA