Steve Wiser wrote:

> I thought the only downfall of selectable stored procedures was that if
> you joined to something else it would not use any indexes. I might be
> wrong or out of date though. With that said, however, we don't use
> views anymore because of the lack of altering.

? why would you need 'ALTERING'
A view is just looking at the existing tables, I just drop, and load the
revised schema. You do document the schemas? ;)

Views are a nice quick way to build a simple view of complex data

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services