<div>
<div class="content wysiwyg-content">
I have a problem that i cant work out how to get around, If a users name changes for what ever reason i need to get the value from the table PCM for OLD_NAME and then add it to NEW_NAME and then update the value of NEW_NAME to the new value<br />
<br />
<br />
Each table will only have 1 record for each User, but their maybe be 20 differnt users that need this calculation of their old/new usernames points.<br />
<br />
RENAME<br />
--------------<br />
OLD_NAME - VChar(20)<br />
NEW_NAME - VChar(20)<br />
<br />
PCM<br />
--------------<br />
NAME - VChar(20)<br />
POINTS - Money<br />
<br />

</div>
</div>


I have a problem that i cant work out how to get around, If a users name changes for what ever reason i need to get the value from the table PCM for OLD_NAME and then add it to NEW_NAME and then update the value of NEW_NAME to the new value


Each table will only have 1 record for each User, but their maybe be 20 differnt users that need this calculation of their old/new usernames points.

RENAME
--------------
OLD_NAME - VChar(20)
NEW_NAME - VChar(20)

PCM
--------------
NAME - VChar(20)
POINTS - Money



get to values and add them toghter then update the value

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.