Transfer SQL to SQL SERVER stored procedure

Question

Can someone help me transfer the logic into an stored procedure, the entire syntax, this is the query I am using in access, i want to transfer to sql server 2008


SELECT CountOfColorValue, ColorTable*, IIf([CountOfColorValue]<7,"Invalid Color",[ColorCode]) AS COLOR STATUS
FROM  INNER JOIN ColorTable ON (ColorLocation=ColorLocation) AND (ColorPart=ColorPart) AND (ColorCode=ColorCode);