Ramon Rocha

Galera, Tenho esta SP no SQL Server: 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 Alguém pode me ajudar convertendo para MySQL? Grato.