Home Forums SQL Server 2005 SQL Server 2005 Integration Services Derived Column to handled mulitple conditions in CASE statement? RE: Derived Column to handled mulitple conditions in CASE statement?

  • May 26, 2013 at 12:58 pm

    #1618617

    You can use below expression in the derived column.

    [Obj Acct] == "0" ? Sub : (Sub == "0" ? [Obj Acct] : [Obj Acct] + "." + Sub)

    Vikash Kumar Singh || www.singhvikash.in