asked
Update and append a column
I have a table to update a column from another column in the same table and also adding a partial value from another table. For example there are three columns in the same table A, B, C. A = 2020 (This is the first column whose last two digits +1 is required) B= 1(This is the second column its value can be from 1 to 12 so if it is 1 to 9 I have to put a prefix 0 so it will be like 01) C= 0121(This is required)
Here you go select 2020 as A , 1 AS B, cast(null as varchar(10)) as C into #t1 --select * from #t1 update #t1 set C = Right('0'+cast(B as varchar(2)),2) +cast(Right(A,2)+1 as varchar(2)) select * from #t1
Thanks..That worked :)
21 People are following this question.
