If you are going with this idea, be kind to your SQL admin and use truncate instead of delete to remove all entries from the temp like table you are creating.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Palyne Gaenir Sent: Thursday, June 06, 2002 4:56 PM To: [EMAIL PROTECTED] Subject: RE: Dynamically Creating Views Thanks Tim, that's a good idea. On 6 Jun 2002 at 16:32, Dudek, Tim K. wrote: > I have done a similar trick to get around Access limitations. > However, I made a table that was permanent and then just dumped > the queryied rows into this table. Use this table in your next > query then after your done just delete the rows from this table. > That trick might be less prone to error then creating and > dropping tables. ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
