Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lekfir
Starting Member
3 Posts |
 Posted - 2008-09-05 : 19:04:58
|
| Hi,I am trying to create an expression with a new column that will be a calculated column.E.G:If the value in column A = "ER", Then, place in the new derived column the value of Column B * 82What is the correct expression to write in order to achive that?Thanks a lot! |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-09-07 : 01:23:57
|
| [Column A] == "ER" ? (DT_I4)[Column B] * 82 : [Column A]Under Derived Column dropdown, select "Replace Column A" |
 |
|
|
|
|
|
Derived Column and Expressions