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.

How an input series enters the model is called its transfer function. Thus, ARIMA models with input series are sometimes referred to as transfer function models. In the preceding regression and ...