This function produces the same result as the ms excel FORECAST function, although the range must be supplied in a delimited string (x,y:x,y...ect):

http://www.sqlservercentral.com/scripts/Forecast/67484/

I use this method when I need a dynamic solution:

use AdventureWorks2000

go

if exists(select * from sysobjects where id = object_id('dbo.proc_dynamic') and type = 'P')

drop procedure dbo.proc_dynamic

go

create procedure dbo.proc_dynamic

@name varchar(50)

as

begin

select LocationId, [Name],...

You really are a veteran.  I've never run into that problem before but it makes sense.  Thanks for the help!