Re: Counting Records

From: TheBoss <TheBoss_at_invalid.nl>
Date: 01 Aug 2011 20:52:00 GMT
Message-ID: <Xns9F34E89CE7C8ATheBossUsenet_at_194.109.133.246>

The Magnet <art_at_unsu.com> wrote in news:93486fc1-ada5-4c6e-8ca7- a66c55ee1003_at_eb9g2000vbb.googlegroups.com:

> Hi,
>
> I have a table with 3 nested tables in it. I want to be able to
> return the number of rows retrieved from each nested table in my
> result set.
>
> This cannot be just a simple count, as if the nested tables have 100
> rows each, but the result set selects 10 from nested table 1, 50 from
> nested table 2 & 25 from nested table 3.
>
> Is there a way for me to get this count?

Redesign to properly normalised parent/child tables.

-- 
Jeroen

Received on Mon Aug 01 2011 - 15:52:00 CDT