>I can't use a view. I guess I could do a cursor.

Michelle,

Why can't you use a view, this is exactly what a parameterized view is for?

A cursor that you recreate will destroy your grid on you and you will have to created it in code.