SQL SELECT or INSERT INTO query

Question

I'm working with SQL Server 2000. I need to take the results from one column (VALIMIT) and insert them into another column (VALIMIT2012) in the same table (lending_limits).

My question is do I need to do a SELECT query first, or do I just start with an INSERT INTO query and what the proper syntax would be for the INSERT INTO query.

Answer 1

You can do this with an UPDATE statement:

update lending_limits
set VALIMIT2012 = VALIMIT