Converting SP SQL Server to MySQL

[Ramon Rocha]

Dear friends,

Somebody help me to convert this SP SQL Server to MySQL?

CREATE PROCEDURE GG_SP_MANAGER_USUARIOS_GETDATAGRID 
@DataForPage AS Int, 
@CurrentPage AS Int, 
@WhereClause AS Varchar(255), 
@SortField AS Varchar(255)
AS 

DECLARE @COUNTER AS Int 
SET @COUNTER = (SELECT COUNT(GG_MANAGER_USUARIOS.Usuario) FROM GG_MANAGER_USUARIOS) 

IF @DataForPage = 0
	SET @DataForPage = 10

IF @CurrentPage = 0
	SET @CurrentPage = 1

DECLARE @SQLStatement varchar(8000) 
SET @SQLStatement ='' +
	'SELECT	' +
		'Usuario, ' +
		'Nome, ' +
		'Sobrenome, ' +
		'Email, ' +
		'Senha, ' +
		'Telefone, ' +
		'DataCad, ' +
		'DataAlt, ' +
		'DataVisita, ' +
		'Visitas, ' +
		'Ip, ' +
		'Grupo, ' +
		'Grupo_Nome, ' +
		'Liberado ' +
	'FROM (' +
		'SELECT	' +
			'GG_MANAGER_USUARIOS.Usuario, ' +
			'GG_MANAGER_USUARIOS.Nome, ' +
			'GG_MANAGER_USUARIOS.Sobrenome, ' +
			'GG_MANAGER_USUARIOS.Email, ' +
			'GG_MANAGER_USUARIOS.Senha, ' +
			'GG_MANAGER_USUARIOS.Telefone, ' +
			'GG_MANAGER_USUARIOS.DataCad, ' +
			'GG_MANAGER_USUARIOS.DataAlt, ' +
			'GG_MANAGER_USUARIOS.DataVisita, ' +
			'GG_MANAGER_USUARIOS.Visitas, ' +
			'GG_MANAGER_USUARIOS.Ip, ' +
			'GG_MANAGER_USUARIOS.Grupo, ' +
			'GG_MANAGER_GRUPOS.Nome AS Grupo_Nome, ' +
			'GG_MANAGER_USUARIOS.Liberado, ' +
			'ROW_NUMBER() OVER(ORDER BY ' + @SortField + ') AS RowNum ' +
		'FROM ' +
			'GG_MANAGER_USUARIOS LEFT OUTER JOIN ' +
			'GG_MANAGER_GRUPOS ON GG_MANAGER_USUARIOS.Grupo = GG_MANAGER_GRUPOS.Grupo' + 
		') AS RegInfo ' +
	'WHERE ( RowNum BETWEEN ' + CONVERT(nvarchar(10), @CurrentPage) + 
            ' AND (' + CONVERT(nvarchar(10), @CurrentPage) + ' + ' 
            + CONVERT(nvarchar(10), @DataForPage) + ') - 1 )'
IF LEN(@WhereClause) >0
	SET @SQLStatement = @SQLStatement + ' AND ( ' + @WhereClause + ' )'
EXEC(@SQLStatement)

RETURN @COUNTER
GO