One of the first things I had to learn to do, early in my life working with SQL. It felt extremely powerful, executing such a small piece of code, and seeing affect many thousands of records.

It was fun. And I was easily pleased in those days.

USE Database1

UPDATE Table1

SET [Column_data2] = [Column_data1]

WHERE Period = ’01/02′