Home Forums SQL Server 7,2000 T-SQL create sql str with special condition RE: create sql str with special condition

  • March 26, 2013 at 12:23 am

    #1600614

    Select a.code, a.price, (price * percent * case when check = 1 then 1 else 8 end) as new_field

    From a,b

    Where a.code = b.code

    ?

    I Have Nine Lives You Have One Only
    THINK!