Nice. Thank you.
----- Original Message ----- From: "BEN MORRIS" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 01, 2002 9:45 AM Subject: Re: Delete Query Help > If you want 10 records deleted... > > DELETE > FROM tablename a > WHERE a.ID IN > ( SELECT TOP 10 b.ID > FROM tablename b > WHERE ... [criteria] > ) > > >>> "Frank Mamone" <[EMAIL PROTECTED]> 04/01/02 09:35AM >>> > Hi, > > I want to delete a specific amount of records matching a criteria. > > I may have many records matching the crteria but I want to delete a specified amount. Is it possible to do this directly with SQL? > > Thank you, > > Frank Mamone > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists