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