Thank you all, as usual I answered my original post without reading the thread...
There is a financial implication which is also a time element as well. You may have seen that I'm evolving from a die hard FoxPro programmer to the new world of .Net. I feel like an amphibian walking on to land for the first time.
Anyway my preference is to keep the logic in t-SQL, partly because I know how it works and it's generally proven. Moving to an intermediate layer in C# or something else would only cause me more grief I think.
I'm also concerned about speed. Putting code next to the data on the same physical box seems logical, but then am I missing something about how a distributed app works in .Net?
Simon