RE: Stored Procedure with different SUMs - STATIC SQL

[rob@xxxxxxxxx]

I was thinking that maybe a CASE clause may work but case is often based 
on the contents of column - not a selection or host variable.

For example if you have a table that looks like this
item
sales2009
sales2008
sales2007
...
you want to do something like
case :hostvar
  when '2009' then sum(sales2009)
  when '2008' then sum(sales2008)
end;

I am not sure this can be done.  Has your DBA heard of something called 
"Third Normal Form"?

Rob Berendt