<div>
Thank you so much, easy when you know how! Hopefully didnt take up too much of your holiday, anywhere nice?<br />
S
</div>


Thank you so much, easy when you know how! Hopefully didnt take up too much of your holiday, anywhere nice?
S

<div>
:-) Indoors - trying to use up holiday allocation rather than losing it!
</div>


:-) Indoors - trying to use up holiday allocation rather than losing it!

<div>
<div class="content wysiwyg-content">
This may be simple to all but just cant get my head around :(<br />
<br />
I would like to search for a value in FA_COST_NOM and if found replace the values in both FA_DISP_NOM and FA_REVAL_NOM, all three fields are in the same FA_ACCOUNTS table.<br />
<br />
i.e.<br />
<br />
FA_COST_NOM &nbsp; &nbsp;FA_DISP_NOM &nbsp; &nbsp;FA_REVAL_NOM<br />
11980 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11960 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11950<br />
<br />
If 11980 is found change the other two fields to 11960 and 11950 respectively. There may be multiple records with 11980 in them. <br />
<br />
Please help.<br />
Regards<br />
S
</div>
</div>


This may be simple to all but just cant get my head around :(

I would like to search for a value in FA_COST_NOM and if found replace the values in both FA_DISP_NOM and FA_REVAL_NOM, all three fields are in the same FA_ACCOUNTS table.

i.e.

FA_COST_NOM    FA_DISP_NOM    FA_REVAL_NOM
11980                   11960                  11950

If 11980 is found change the other two fields to 11960 and 11950 respectively. There may be multiple records with 11980 in them. 

Please help.
Regards
S

Search field and replace two others

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.