uliasz.com

Just another WordPress site

CTE

How to refer to previous row in SQL 2005

In this post I will describe simple mechanism allowing to refer back to previous row in SQL Server 2005/2008 database table.   For the purpose of this article let’s create a table dbo.AgentLog:   create table dbo.AgentLog…

Categories

Tags

.NET Ajax ASP.NET ASP.NET MVC C# CTE Entity Framework git JavaScript jQuery SQL SQL Server T-SQL Unit Testing WCF Web Services XAML XML