<div>
<div class="content wysiwyg-content">
So, I have a table, lets say with the following cols/data<br />
<br />
EMPID &nbsp; &nbsp; Value01 &nbsp; &nbsp;Value02 &nbsp; Value03<br />
0001 &nbsp; &nbsp; &nbsp; &nbsp;Test01 &nbsp; &nbsp; &nbsp;Test02 &nbsp; &nbsp; &nbsp;0<br />
0001 &nbsp; &nbsp; &nbsp; &nbsp;Test02 &nbsp; &nbsp; &nbsp;Test03 &nbsp; &nbsp; &nbsp;0<br />
0001 &nbsp; &nbsp; &nbsp; &nbsp;Test04 &nbsp; &nbsp; &nbsp;Test05 &nbsp; &nbsp; &nbsp;0<br />
0002 &nbsp; &nbsp; &nbsp; &nbsp;Test01 &nbsp; &nbsp; &nbsp;Test02 &nbsp; &nbsp; &nbsp;0<br />
0002 &nbsp; &nbsp; &nbsp; &nbsp;Test02 &nbsp; &nbsp; &nbsp;Test03 &nbsp; &nbsp; &nbsp;0<br />
0002 &nbsp; &nbsp; &nbsp; &nbsp;Test04 &nbsp; &nbsp; &nbsp;Test05 &nbsp; &nbsp; &nbsp;1<br />
0003 &nbsp; &nbsp; &nbsp; &nbsp;Test01 &nbsp; &nbsp; &nbsp;Test02 &nbsp; &nbsp; &nbsp;0<br />
0003 &nbsp; &nbsp; &nbsp; &nbsp;Test02 &nbsp; &nbsp; &nbsp;Test03 &nbsp; &nbsp; &nbsp;0<br />
0003 &nbsp; &nbsp; &nbsp; &nbsp;Test04 &nbsp; &nbsp; &nbsp;Test05 &nbsp; &nbsp; &nbsp;1<br />
<br />
So, what is important is columns EMPID and Value03. &nbsp;The other columns are irrelevant. &nbsp;Basically what I need to do is if the value in column Value03 = 1 then update that column = 1 for that EMPID. &nbsp;<br />
<br />
So EMPID -&gt; 003 would have a value 1 in each Value03 column and same for EMPID -&gt;002
</div>
</div>


So, I have a table, lets say with the following cols/data

EMPID     Value01    Value02   Value03
0001        Test01      Test02      0
0001        Test02      Test03      0
0001        Test04      Test05      0
0002        Test01      Test02      0
0002        Test02      Test03      0
0002        Test04      Test05      1
0003        Test01      Test02      0
0003        Test02      Test03      0
0003        Test04      Test05      1

So, what is important is columns EMPID and Value03.  The other columns are irrelevant.  Basically what I need to do is if the value in column Value03 = 1 then update that column = 1 for that EMPID.  

So EMPID -> 003 would have a value 1 in each Value03 column and same for EMPID ->002

SQL - Update column per Emp

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.

Microsoft SQL Server 2008

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.