Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Update Query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-25 : 13:40:29
Rene writes "Hello specialists,
My problem is the next :

I want to update records with different criteria in one query.

I will show you what I mean :

Set amount to $100 when member=senior
Set amount to $75 when member=junior
Set amount to $50 when member=pupil

Is this possible in one query, or should I make three?
I hope to hear from you.
Greetings René Laan"
   

- Advertisement -