Hi All,
i understand normal paging using using a stored procedure, but how would i page a resultset that has a row with multiple sub rows (like one-to-many relationship i guess)
for example. say i return 5 recs per page:
id name subid name
1 a 1 w
2 b 2 x
3 c 3 y
4 c 3 y
5 d 4 z
if i was displaying this(in asp), then only 4 recs would show, as rows 3 & 4 would show as one.
any ideas how to do this????
cheers
mitSiguRi
i understand normal paging using using a stored procedure, but how would i page a resultset that has a row with multiple sub rows (like one-to-many relationship i guess)
for example. say i return 5 recs per page:
id name subid name
1 a 1 w
2 b 2 x
3 c 3 y
4 c 3 y
5 d 4 z
if i was displaying this(in asp), then only 4 recs would show, as rows 3 & 4 would show as one.
any ideas how to do this????
cheers
mitSiguRi