stored procedure

I have a stored procedure in sql that I am calling from vba in excel (using ADO). The stored procedure Inserts a record into the db table with 7 parameters. The worksheet has 7 columns. There could be 100 or more rows at one time on the worksheet that I want to insert to the sql db using the...

Hey, I need a way to calculate overlap between Groups but not within the same group. I need to make a template where a user can input the group name and the Numbers associate and have a easy checker to see if there is any overlap between the groups. Ideally there is a Button which runs a Macro...

Hi, I'm having a bit of trouble getting a recordset to return anything when I run a stored procedure through my VBA. I have tried "SET NOCOUNT ON" and there are results when I have a global temptable. I think this piece of code is where I'm having trouble. Set adoRs = New adoDb.Recordset...

Hi, I've have the code below to fill a combobox with data from a mySQL stored procedure. The SP selects the customer code and customer name. Depending on what customer code the user chooses, I need to populate a textbox with the associated customer name. Please could somebody help me with the...

I have a stored procedure which looks like: PROCEDURE validate_upload ( p_delete IN NUMBER, p_budget_id IN NUMBER, p_upload_id IN NUMBER, p_user IN VARCHAR2, p_result OUT VARCHAR2 ) , but how do I run the procedure and how can I get the returned message? I know...

I have some stored procedures which I am not able to see. I know that some parameters have to be NULL. But I don't know what it means if a parameter in a stored procedure "the_function(x, y, z)" has to be NULL. Should it be written as NULL or just an empty string; the_function(NULL) or...