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
deshpandevd
Grasshopper
Points: 19
More actions
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