Home Forums SQL Server 2012 SQL Server 2012 - T-SQL String Updation in a formula of a table -Query required RE: String Updation in a formula of a table -Query required

  • September 16, 2016 at 9:46 am

    #1901388

    Anandkumar-SQL_Developer (9/16/2016)

    Solution :

    select [KPI ID]

    ,[KPI Name],

    [KPIFormula] = case when [kpi id] = 'SA2' then '[QW1]+[SA2]+[BG7]'

    when [kpi id] = 'XS3' then '[QW1]+[BG7]'

    when [kpi id] = 'BG7' then 'BG7' else [kpi id]end

    from #kpi

    ...and if there are thousands (or millions) of KPI's???

    I'm pretty sure I'd rather slit my own wrists than manually rewrite every formula.