Create procedure problem

2004-08-25 Thread Joe Byers
I want to create a stored procedure that I pass a date variable and two database names. I can not seem to figure the correct syntax to utilize these variables in the procedure. I think I might need to build a sqlstring and use an exec command to execute the string. Here is my procedure code:

Aggregating functions Enhancement and extension

2004-08-25 Thread Joe Byers
MYSQL new feature The aggregating functions std and variance calculate the population standard deviations and variance. I work extensively with datasets doing statistical analysis. Many times it is faster and more efficient to perform the basic univariate statistics on the server but I need the