spirose
asked on
SQL syntax
If I have a column 'Property' in Table 'TableTrial' with value 'EmployeeIDInitial|Employe eIDFinal', how do I update the value of Property to (2 different values)
1. 'EmployeeIDInitial'
2. 'EmployeeIDFinal'
1. 'EmployeeIDInitial'
2. 'EmployeeIDFinal'
== > to update the EmpIdInitial value
update yourtable
set property = 'yourvalue'
from dbo.TableTrial
where property='EmployeeIDInitia l'
=== > to update the EmpIdFinal Value
update yourtable
set property = 'yourvalue'
from dbo.TableTrial
where property='EmployeeIDInitia l'
update yourtable
set property = 'yourvalue'
from dbo.TableTrial
where property='EmployeeIDInitia
=== > to update the EmpIdFinal Value
update yourtable
set property = 'yourvalue'
from dbo.TableTrial
where property='EmployeeIDInitia
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great- just what I needed
Thanks for the grade. Good luck with your project. -Jim
Do you mean two different records, or two different columns?