Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by nmalhot
-
Please help to understanding deadlock problem ...
Awesome. Paul, thanks so much for your time and insight. I'm making the change and keeping my fingers crossed! :)- nmalhot
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Query Issue
you should be able to use WHERE dateField > '10-Nov-2006' and it will return any rows where datefield is after 10-Nov-2006 00:00:00- nmalhot
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Please help to understanding deadlock problem ...
I think I understand the basics of what causes deadlocks but I keep having a deadlock on this update statement and I can't understand why or how to fix the problem. Any insights would be much appreciated! UPDATE player SET money = money + a.salary FROM #wages a (NOLOCK), player b...- nmalhot
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
