>>I guessed when you originally posted, that you didn't have a working solution. You asked a question, we're given an answer, threw out the answer and went your own way. If you don't want to discuss the options, don't ask the question.
>
>I am thinking that for the next part of this method I am converting from VFP into C# I do need to create two stored procedures.

If you are going to use a SP then you may as well put all the logic there.....