Basic MSSQL Query help

[sethupathy22]

Hi guys,

i need to change (i guess update) the value on a specific row depending on the value of another row. Let me be more clear.

i have values in code rows and i have a choise box with actif and inactif named member

I need to set member to actif if there is any type of value in code. i have over 700 to change the value i dont want to do them manually.

Can someone help

Thank you

[ck9663]

Hi guys,

i need to change (i guess update) the value on a specific row depending on the value of another row. Let me be more clear.

i have values in code rows and i have a choise box with actif and inactif named member

I need to set member to actif if there is any type of value in code. i have over 700 to change the value i dont want to do them manually.

Can someone help

Thank you

Do you have two tables? You said " depending on the value of another row". Would you mind posting your sample data and your desired results?

-- CK

[JovieUrbano]

Hi guys,

i need to change (i guess update) the value on a specific row depending on the value of another row. Let me be more clear.

i have values in code rows and i have a choise box with actif and inactif named member

I need to set member to actif if there is any type of value in code. i have over 700 to change the value i dont want to do them manually.

Can someone help

Thank you

try this

update <table> set memberstatus='i nactif' --- set all members to inactif
update <table> set memberstatus='a ctif'
where valuesINcodeROW S not in ('', ' ', NULL)

hope this helps