it is not simple like that
i have 2 repeaters one inside other
with one select i binding two arraylists for the repeaters
recordset is something like this:
1 2 2 2 2
1 3 3 3 3
1 4 4 4 4
2 1 1 1 1
2 2 2 2 2
....
First repeater is based on the first column
If I put top 5 in the select I will get only two rows in the first repeater,
but i need to limit second repeater on just 5 rows.
I still think this sort of things should be done on select stage. May be you
should consider using only one repeater bound to one joined recordset. You
can use select with outer join for that. Then select top 5 will do the job.