Home Forums SQL Server 2005 Development 2008 R2 Adding a columm with time differences between transactions per employee/date RE: 2008 R2 Adding a columm with time differences between transactions per employee/date
pietlinden
SSC Guru
Points: 63434
More actions
February 26, 2015 at 9:40 pm
#1780462
Found this article:
http://www.sqlservercentral.com/scripts/LAG/89769/
If you had 2012, you could use LAG or LEAD to look at previous/next records and do math on values between records, but since you can't...