Home Forums SQL Server 7,2000 Globalization how to compare value of two fileds and based on that insert value into third fileds RE: how to compare value of two fileds and based on that insert value into third fileds

  • February 25, 2009 at 2:18 am

    #949841

    Do simple thing write a simple query like this you will get actual result.

    SELECT nametype1, nametype1, CASE WHEN nametype1= nametype1THEN '1' ELSE '2' END AS nameval

    FROM temp