I want to design a query to compute some returns for stock data and in searching the 'SQL Server Books Online' I find a very small and not so helpful at all help section on the lead and lag functions.

The SQL query language was designed to provide programmers with a way to create, maintain and modify databases in a structured way. Using SQL, the programmer can add and remove items from databases as ...