remove a record from one account to another accoun

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)

remove a record from one account to another accoun

Author

Topic

ntn104
Posting Yak Master

175 Posts

Posted - 2008-10-01 : 09:47:27

Hello,

I need somebody to help me to figure how can I move one client from this lawyer to another lawyer. For example, I want to move below record (from lawyer2) to lawyer1 in the same table.

CaseID LawyerID FileNo Lname Fname
222111 131063 4596-0555 UR Pane

Thanks,

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-01 : 09:49:14

UPDATE Table1
SET LawyerID = 360131
WHERE CaseID = 222111

E 12°55'05.63"
N 56°04'39.26"