Posted by Tradeorganizer on 01/31/07 04:50

On Jan 30, 6:47 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> Hi,
>
> You do not specify what is the logic for generating the values for the
> nameval column, but based on your example seems it is 2 when the values are
> equal and 1 when they are different.
>
> Based on that assumption, here is a query that will do the update:
>
> update test
> set nameval = (case when nametype1 = nametype2 then 2 else 1 end)
>
> Regards,
>
> Plamen Ratchevhttp://www.SQLStudio.com


hi i have an update to the query , please suggest if the table
structure and results are below then what should i run for no of
fileds

name varchar (20)
address varchar (20)
position varchar (20)
nametype1 varchar (20)
nametype2 varchar (20)
nametype3 varchar(20)
nametype4 varchar(20)
nameval varchar(20)
nameval1 varchar(20)
nameval2 varchar(20)
nameval3 varchar(20)

now in the nametype1 and nametype2 there are values like
nametype1 nametype2 nametype3 nametype4
"AB" "BA" "BB" "BB"
"AA" "AA" "BA" "AB"
"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
"AA" "AA" 2
"AB" "BA" 1
"AA" "AA" 2

nametype1 nametype3 nameval1
"AB" "BB" 1
"AA" "BA" 1
"AB" "BB" 1
"AA" "BA" 1

nametype1 nametype4 nameval2
"AB" "BB" 1
"AA" "AB" 1
"AB" "BB" 1
"AA" "AB" 1

please suggest query in sql which i can run to do this also i would
like to know is it possible to have some kind of loop which can check
each nametype with other like the combination above please suggest.

Regards

• Next in forum: Re: how to compare value of two fileds and based on that insert value into third fileds
• Prev in forum: Re: Help With complex SELECT
• Thread view: Re: how to compare value of two fileds and based on that insert value into third fileds

[Reply to this message]