Philip Hendry's Blog
Sporadic musings from Philip Hendry

Generic Sorting Routine for ASP.NET GridView

Sep 18, 2009 • ASP.NET, Problem, • 2 min read

I noticed a lot of code in the current project I’m working on which looked something like this :  Read →

Importing from Excel into SQL Server

Sep 15, 2009 • SQL Server, T-SQL • 1 min read

I was going through a mountain of pain trying to get an import working from an Excel spreadsheet working into SQL Server 2005 but I finally managed it and here’s how…  Read →

Conditional Aggregate Totals in SQL

Sep 11, 2009 • SQL Server, T-SQL, Tip • 1 min read

I’ve been working on a SQL Server Reporting Services report which had to display several counts on each row. Each row represented a project and each project could have several tasks that were either ordinary tasks or milestones and could also be escalated. The report need to show something like this :  Read →