IN sql 2005, you can also look up the PIVOT operator. In SQL 2000, you still had to use the CASE statement as follows:

Select

SalesPersonID,

JanSales = Sum(Case when month(SaleDate) = 1...

There are a couple of ways to tackle this. Maybe the least coding is to do a dynamic sql string.

something like

Declare @sql varchar(4000)

Set @sql = 'Select * From table Where...

You can get the value from the inserted table.