I had figured that out though
Now i have a new question.
Which is the most effective way to update a field based on multiple conditions?
I've seen a sort of switch statement with various cases but everyone was complaining about it being stupid.
It looked like the statement in here: http://www.java2s.com/Code/SQLServer/Select-Query/UseCASEintheUPDATEstatement.htm
I don't absolutely need it since it's a once a day query but i like to do things the right way