Link to home
Start Free TrialLog in
Avatar of Amanda Walshaw
Amanda WalshawFlag for Australia

asked on

inserting text fields sql database table

The accounting team have decided to change 150 descriptions of their chart of accounts.
the chart of account remains the same etc only the description changes.
I was thinking an insert statement would be the best way to go

would you create a table with the changes required then do an insert
SELECT column_name,column_name
 FROM table_name
 WHERE column_name operator value;

see example attached
changing-descriptions.xlsx
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

It would probably be an update statement.

First add an additional field to the existing table, say, description.

Then

Update yourExistingTable

Set description = 'value' where accountCode='accoutncodeValue'

It will be tedious but that's the only I can ensure desciptions go to correct accountCode value.
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial