Hi,

I have the following stored procedure:

CREATE PROCEDURE ACC_usp_Next_Number @cTableName char(40),@cField AS CHAR(40),@iNext int OUTPUT AS

DECLARE @cSQLString VARCHAR(256)

SET @cSQLString = 'SELECT @iNext = MAX('+@cField+') FROM '+RTRIM(@cTableName)

EXEC(@cSQLString)

RETURN @iNext
GO


I get the error "Must declare the variable '@iTest'.". Basically I would like to get the next number of the table and field that I pass. Why is it telling me to declare @iTest if I'm passing it? Does anyone know of a better way to accomplish this?

Thanks.