I just spent a day or so (9 hours) working on an efficient solution to paging a report that pulls from hundreds of thousands of records a variable amount of records per page, so thought I'd share. I had some criteria The solution needed to use one(1) call to the database The solution needed to accept multiple parameters to refine the ...

So I wanted to store a history of an order any time Customer Service made a change to an order.  This is something their old software didn't do, and I thought it should be nifty. But then I looked at how each order was spread out amongst 6 different tables and I didn't really want to clutter the database up with copies of all the different ...