SELECT TOP(SELECT CASE WHEN COUNT(*) > 0 THEN COUNT(*) ELSE 1 END * @PageSize
                           FROM   dbo.grupos
                           WHERE  Loja = @lojaId) *
                FROM   (SELECT *,
                               ROW_NUMBER() OVER (ORDER BY  Nome DESC, Id) AS row_number
                        FROM (SELECT
                                    G.ID as Id,
                                    G.NOME as Nome,
                                    'ExisteSubgrupoVinculado' =
                                        (SELECT CASE WHEN EXISTS(
                                            SELECT C.*
                                            FROM CATEGORIAS C
                                            WHERE C.GRUPO = G.ID
                                            AND C.LOJA = G.LOJA)
                                        THEN CAST(1 AS BIT)
                                        ELSE CAST(0 AS BIT)
                                        END)
                                    FROM GRUPOS G
                                    WHERE G.loja = 603
                             ) tb1
                       ) tb2
                WHERE tb2.row_number > @PageRowNumber
                ORDER BY  Nome DESC, Id