At the moment i've having to use views, but this limits me massivly when it comes to more complex querys.

Do retirevial SP's have any build in paging support?

Thanks

There is no such thing as paging in a normal SP. Some optinons:

A. If you are using a GridView, use the paging of the GridView, all results will be fetched eachtime you'd select a page, and the grid will just display the needed records. (Not effecient)

B. Implement paging in your SP, add a couple of parameters for the page number & page size.

C. You can project the results into an entityCollection, and use the client side EntityView filtering. Then you can implement your own Client-Side paging mechanism.