I attempted searching around, however, I couldn't find anything that would help me out.
I'm attempting to do this in SQL:
I know that I shouldn't have to put '= @locationID' at the end of each one, but I can't get the syntax even close to being correct. The SQL keeps on complaining about my '=' on the first WHEN line...
How will I do this?