This resource will guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon to perform; Transact-SQL Reference ...
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.