over-clause

What exactly does the "Over" Clause in T-Sql do?

I'm starting to mess with ASP.NET MVC and came across the issue of wanting to do some basic Paging. So I used this simple Linq statement (using the Northwind Database) to get 10 items for a specific page: var q = (from p in db.Orders orderby p.OrderDate descending select p).Skip(currentPage * pa...

How to combine assignments by date range from two data sets into a single data set containing unique overlaps

I have a table that houses assignment attributes for people and the date ranges that each attribute was assigned for. The table has the following fields: PersonId, AssignmentType, AssignmentValue, StartDate, EndDate Each person has an assignment type of racfId and cmsId which can independently start and end at arbitrary times. What i a...