The reason I asked is that you can get prior row data in SQL 2012 with LAG function. In SQL 2008 you will need to go with OUTER APPLY approach instead.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles
No comments:
Post a Comment