Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silvershark
Starting Member
48 Posts |
 Posted - 2008-12-29 : 20:08:34
|
| I have a column of CUSTOMER and everytime a row is updated I want the same information to be copied to column Employee.Is there a way in SQL to acomplish this?IE: When you have CUSTOMER 18, I want number 18 to be entered into column Employee for that corresponding customer.Thanks!Table name is AR_CUST |
|
|
silvershark
Starting Member
48 Posts |
Posted - 2008-12-29 : 20:41:57
|
| Nevermind. Sorry, I am a bonehead. I am tired. I just added a trigger to the table. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 01:05:26
|
| didnt understand reqmnt. you want same info to be entered to two columns? |
|
|
|
|
|
|
Column information update to another column...