ID ColumnA ColumnB
Hello. I am using MS-SQL 2005
I need to make few data transfer.
I have a table called Board Table with Column A and B.
Column A data type is nvarchar(20) and Column B is a new column with data type int.
Also column A has 3 different values that is all mixed in the column(Pending,Escalated,Completed)
I want to make a data copy to ColumnA to ColumnB. If it's Pending, value can 1. If it's Escalated, value can be 2, Completed value can be 3.
How do I make those kind of query.