Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Update statement returns error due to duplicates

Author  Topic 

hansont
Starting Member

8 Posts

Posted - 2008-02-26 : 22:09:57
Hi All,
When I use the following I get an error because of duplicate records in my table.

Update person
Set username = (Select update_person

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-02-27 : 00:14:52
This is actually an easy problem to solve. All you need to do is

e4 d5 xd5 Nf6
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-27 : 01:50:37
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97983

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -