Hi, following on from my previous two posts about Analytic Functions, and specifically about the lack of a T-SQL equivalent to the LAG and LEAD functions I demonstrated, there is a SQL Server feedback vote currently active which you can participate in if you are interested in seeing these functions incorporated into a future update.
The vote can be found here
James