^^ Ill have to chew on your code a bit as im still learning myself. But this is my final and working code.

update aa

set status = 'N'

from people as...

My result set on the above code looks like this:

dont updateFALLPT2008

updateSPRINGFT2008

updateFALLFT2007

updateSPRINGFT2007

updateFALLFT2006

updateSPRINGFT2006

I just want to update the FIRST SPRING FT 2008 RECORD. Since it has a value of FT instead of...

To Clarify:

I know i should provide DDL code to create the table/data but unforunetly I dont know how to do that. BUT, I have the below code:

select case...

craig (8/21/2008)

---

Not sure where im going wrong here, but I adjusted your code slightly to fit my needs. But when I try to run the update statement I recieve the...

Not sure where im going wrong here, but I adjusted your code slightly to fit my needs. But when I try to run the update statement I recieve the error...

Jack Corbett (8/20/2008)

---

Glad I could help.

Just a little tip, you should share what you are really trying to do, unless doing that would violate some policy at your office. ...

Jack Corbett (8/20/2008)

---

Glad I could help.

Just a little tip, you should share what you are really trying to do, unless doing that would violate some policy at your office. ...

^^ Thank you! I will begin testing this with my actual tables. I wasnt aware you would do an update directly from a case statement.

*edit*

I dont need to directly store...

Jack Corbett (8/20/2008)

---

craig (8/20/2008)

---

Thanks, but your case statement doesnt take into account for leap years, or peoples birthdays who have yet to occur yet in the current year. But the...

Can...

Thanks, but your case statement doesnt take into...

Thanks again, you saved me a bid headache. I just got stumped for some reason, but lesson learned.

mtassin (4/3/2008)

---

Because you used EXISTS/NOT EXISTS instead of IN.

Books Online

---

When a subquery is introduced with the keyword EXISTS, it functions as an existence test. The WHERE clause of the outer...

The people code id identifies the person, but the table has a composite primary key with these columns

people_code_id

test_id

test_type

test_date

does this change anything?

Can you explain why this doesnt work?

select *

from testscores as ts1

where alpha_score_1 like 'f%'

and not exists (select * from testscores where alpha_score_1 like 'p%')