Ayuda con un stored procedure

[Jefe_Negro]

Prueba asi a ver que pasa:

Código:

CREATE PROCEDURE [codigomayor] 
( @campo as varchar, 
@tabla as varchar 
) 
AS 
DECLARE @SELECT NVARCHAR(512)

SET @SELECT =  'select Max (' + @campo + ') from ' + @tabla

 EXEC sp_executesql @SELECT