Monthly Archives: March 2010

Using the SQL 2005 Pivot Clause

Let’s say you are querying interview table for the interview id 488 Lets say we are only interested in these 3 disease specific fields Lets get the interview values for the above fields along with the values from the interview … Continue reading

Posted in Development, Uncategorized | Tagged , | Leave a comment

using Enums as data source for a drop down list box in

We can discuss the merits of using enums as data sources at a different time. But I needed to use an enum as datasource and wanted to have a space in one of the enum values. The article by Luke … Continue reading

Posted in Development | Tagged | 1 Comment