SQl server R2 -Already i have a table with data like id name advisorcode 1 AAA 1010100001 2 BBB 1010100002 3 4 etc now i want to update advisorcode like 101100001,1011100002 etc pls give some idea Thanks