Is there a way to delete a number of records in one SQL statement? i.e. I want to maintain a history of 12 records per user. Once a month when I run my scheduled tasks I would like to delete the oldest records over the 12.
Deleting the oldest record isn't a problem. but if I need to delete 4 records how would I do this with out looping over the query 4 times? using CF5/NT4.0/SQL7.0 Thanks Rodney ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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