Sorry I meant to address Kris Sledge in my last post

Ninja,

That was a fair assumption. It's asp.net 2.0 application, effectively using a type submit button with a javascript qty check onclick returning bool whether to submit or not, so it...

Ken, your solution is somewhat cleaner that mine; using the hashed basket id as the unique resource label, not using a transaction and using Session as the owner, and selecting the top 1,...

I've decided against using xlock and I'm now going to use something based on http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/6/30.aspx custom locking and http://www.4guysfromrolla.com/webtech/041906-1.shtml try and catch statements for SQL Server 2005.

I have tested using a...

I have made bold an interesting discovery. The pairs labelled (n) have the same hashed basket id but not the exact same datetime stamp, but they are either almost exactly...

Although the records are duplicates, legitimate items can still be related to the same hashed basket id via a basket id reference so I can't remove them immediately. The only...

Thanks for your reply GilaMonster. My initial thoughts on a fix were to add a unique constraint on that field but as the table is live and already has duplicate...

Not that I know of so I would just use this:

select

'Month' =

case len