Lino Tadros and John Waters had the honor to speak at this year's annual Microsoft DevReach conference in Sofia, Bulgaria. The talks were on Linq, Silverlight and AJAX.

I see this pattern all the time: you need aggregated data from one table, but from multiple different ranges. A very common example of this is a table that holds some kind of date-related data, and a report that displays current month and year to date. For the purposes of this article, let's create a simple, denormalized table that holds accounting data:

create  table Account (
  AccountNum  int
)

create  table AccountActivity (
  AccountNum  int,
  Date  datetime,
  Amount  money
)

To generate the kind of results I described above, I often see queries that look something like this:

create  procedure...

I am currently attending the Telerik sponsored DevReach conference in Sofia, Bulgaria. I was invited to speak, along with Lino Tadros, and did a talk about how to architect a high performance ERP system using AJAX and Telerik controls.

It has been a great conference, with some 400 attendees. The Bulgarians are definitely a force to be reckoned with when it comes to .NET development, as evidenced by Telerik. I was amazed to learn in one session that had 50 attendees, that all 50 used C# and none used VB.Net!