Hi all, Is it possible to create views that take parameters? Basically, I have to create some very complex historical
reports,and as of now I am using temporary tables to store intermediate query results. I calculate values based on the
contentof these temporary tables and use them in the final result. I would like to eliminate the need for temporary
tablesand use views instead, as the data copy between the temp tables is taking quite some time.
Thanks,
Kashmira