• I would just use in line TSQL with a begin/end and declaration of vars - no need to have a SP