Mike Kear wrote: > Dont use @@Identity. Even the books on line (the online help for
where exactly? > Dont take our word for it, read the books online entry. It seems the again where exactly? > It's not MY words saying dont use it, its MICROSOFT's own help file > that says @@Identity has risks of giving the wrong answer, especially > when you have many inserts going on simultaneously. oh my, where does BoL say that? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

