Muliple View are not a feasible option. The WHERE cause is being built dynamically on a web page and the number of columns possible are over 20.

Go back to my original request :

I cant use a CURSOR because EXEC are not allowed in CURSOR SELECT statement.

is this true? do I have any other means to Cursor through the results. If so problem solved.

Edited by - ccarns on 06/19/2003 12:27:35 PM