No,I use guid to sepeartae a company specific data.....inside all tables not one for each company

Could you give me a little example that would work on like a Northwind or something.Likethe tsql statement so I can test the theroy.

I am unsure of what settings are set on this server.I was tasked to come up with a set of records locking and updating query.IF I use the falg column...

I believe you are close....It is a concurrency issue.I have a flag or status that I can flip.I must prevent the second and any other queries from pulling the same...