Scottwright,
In the context you're using IF @UserID statements, you should use SELECT CASE instead as there can only be one true.
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.