Monthly Archives: September 2010
How to refer to previous row in SQL 2005
| September 22, 2010 | Posted by Matt under SQL |
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 ( AgentID int ,LogInTime datetime ,LogOutTime datetime ) go insert dbo.AgentLog select 1, ’2010-09-08 09:40:00.000′, ’2010-09-08 10:14:00.000′ union all select…
Cascading dropdowns with just a bit of Ajax in ASP.NET 2.0
| September 7, 2010 | Posted by Matt under .NET, Ajax, Web |
In this sample I am going to go through very common idea of cascading dropdowns. Very basically speaking it is all about having set of dropdowns where next dropdown is populated on the basis of value selected from previous one. Let’s start with very simple xml document: <?xml version=”1.0″ encoding=”utf-8″ ?> <People> <Person ID=”1″…
I am IT professional with over 10 years of experience in computer programming and web development, specializing in Microsoft technologies.
Recent Comments