Posted by Tradeorganizer on 01/30/07 08:36

Hi,

I have a database with table name as test in that i have 6 colums
they are

name varchar (20)
address varchar (20)
position varchar (20)
nametype1 varchar (20)
nametype2 varchar (20)
nameval varchar(20)

now in the nametype1 and nametype2 there are values like
nametype1 nametype2
"AB" "BA"
"BB" "BB"
"AA" "AA"
"BA" "AB"

now depending upon the combination i want to assign value to the thrid
field that is nameval like example below

nametype1 nametype2 nameval
"AB" "BA" 1
"BB" "BB" 2
"AA" "AA" 2
"BA" "AB" 1

please suggest query in sql which i can run to do this .

Regards

• Next in forum: Re: Storing SQL Server 2005 objects and queries in Perforce
• Prev in forum: attn: leona - truly intuitive pictures - ilto og - (1/1)
• Thread view: how to compare value of two fileds and based on that insert value into third fileds

[Reply to this message]