Código SQL:
Ver originalCREATE PROCEDURE dinamico (@tabla VARCHAR(MAX)
AS
BEGIN
DECLARE @query VARCHAR(MAX)
SET @query='select * from ' + @tabla + 'where CodPesAnt>=1000 and CodPesAnt<=1094
GROUP BY [CodPesAnt]
order by [CodPesAnt] asc'
EXEC Sp_sqlExec @query
END
Saludos!