David Emerson
newsgrps at dalyn.co.nz
Wed Sep 12 21:42:57 CDT 2007
Doing some more research it may be that temporary tables cannot be altered. I cannot create and alter a physical table because the application running the procedure is web based and could be run simultaneously by several users. Perhaps there is a way to build a string to run when the table is initially declared? I am not sure that this is possible either. Anyone any suggestions as to how I can get around this one? Regards David Emerson Dalyn Software Ltd Wellington, New Zealand