Can you explain what you need to do? Sql Server works best with sets and recursion is typically a row by row operation. My guess is that there is a set-based solution to your problem.