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

Re: Create procedure problem

2004-08-25 Thread Martijn Tonies
Hi Joe, 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