You're a distributor supplying the mass market with all sorts of paint and painting accessories. Your customer base is made up of individual consumers, as well as stockists, and third-party suppliers.

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.