> Wouldn't READ COMMITTED do the trick? ...will never read data that another > application has changed and not yet committed
No. Another process could insert a record into the table and commit its change before you select out the max. The ONLY way for the max() record to be yours is to prevent ALL OTHER processes from touching the table. Or, just make life easy on yourself and use scope_identity(). ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
