Nuacht

Yeah I see now off of MSDN that those lead and lag functions are only supported in SQL Server 2k through the MDX Functions. (Analysis Manager) So without these lead and lag functions at my ...
The solution is a massively parallel database with an integrated analytics engine that leverages the MapReduce framework for large-scale data processing and couples SQL with MapReduce.