Stored Procudure With Multiple Select... Incorrect Syntax Near 'storedProcedure'

Hi,





Im fairly new to writing stored procudures so I thought you lot might be able to help with this problem.





I have a stored procudure which looks like this:





CREATE PROCEDURE usrCienet.spAdminAgencyActivate_Select


(


@strAgencyId CHAR(6)


)





AS





DECLARE @idAgency INT





SELECT @idAgency = idAgency FROM tblAgencies WHERE strAgencyId = @strAgencyId;





SELECT strName, strAddress1, strAddress2, strCounty, strCountry, strPostcode, strTelephone, strFax, bitActive, bitHeadOffice, bitFinanceBranch


FROM tblBranches


WHERE fk_idAgency = @idAgency





SELECT strFirstName, strSurname, strUsername, bitActive


FROM tblUsers


WHERE fk_idAgency = @idAgency





GO





It basically first declare's and sets @idAgency using the first small select statment, then uses that parameter to run two more selects queries which I want sending to a dataset. Now within the Query Analyzer this works fine. But in my asp.net page it trows up this error:





Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'spAdminAgencyActivate_Select'





Now the code im using in the asp.net page is as follows:








Dim objSqlConnection as New SqlConnection(ConfigurationSettings.AppSettings("strCon"))


Dim objSqlCommand_Select as New SqlCommand("spAdminAgencyActivate_Select", objSqlConnection)





objSqlCommand_Select.Parameters.Add(New SqlParameter("@strAgencyId", SqlDbType.Char, 6))


objSqlCommand_Select.Parameters("@strAgencyId").Value = "tes001"





Dim objSqlDataAdapter as New SqlDataAdapter(objSqlCommand_Select)





Dim dsActivateAgency as New DataSet()





objSqlConnection.Open()


objSqlDataAdapter.TableMappings.Add("Table", "tblBranches")


objSqlDataAdapter.TableMappings.Add("Table1", "tblUsers")


objSqlDataAdapter.Fill(dsActivateAgency)


objSqlConnection.Close()








Can anyone help? I believe the error is in the stored procedure somewhere, because if I change the stored procedure so no parameters are being passed to it then it starts working. This is what I comment out and change for it to to get it working, but obviously this is not satisfactory as a final result because the parameter is hard coded in the stored procedure. Im just showing this to see if it gives anyone a clue!!





CREATE PROCEDURE usrCienet.spAdminAgencyActivate_Select


--(


--@strAgencyId CHAR(6)


--)





AS





--DECLARE @idAgency INT





--SELECT @idAgency = idAgency FROM tblAgencies WHERE strAgencyId = @strAgencyId;





SELECT strName, strAddress1, strAddress2, strCounty, strCountry, strPostcode, strTelephone, strFax, bitActive, bitHeadOffice, bitFinanceBranch


FROM tblBranches


WHERE fk_idAgency = 1





SELECT strFirstName, strSurname, strUsername, bitActive


FROM tblUsers


WHERE fk_idAgency = 1





GO





Thanks in advance for any help!!





- Carl S