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 ...