We have a similar problem to the one this function attempts to solve. Often we need to determine the paydate in a BiWeekly payroll. We have to include...

A little off topic.  I have seen similar results (slow .NET access but fast in Query Analyzer) that seemed to be solved with "SET ARITHABORT ON".  Maybe by doing that...

In case someone wanted Brian's solution broken down into its process and components I went back through and did that.

Process:

1. Select all the rows (MyTable)

2. SubQuery:  Get the highest Code...

This one is a little ugly but it should work.  Depending on your real purpose this might be a job for a cursor.  Otherwise, if you are using SQL 2005...

You might consider tools like Red Gate's SQL Compare which compares the structure of two databases and allows you to synchronize them, and possibly their SQL Data Compare which allows...

If it returns very quickly (more quickly than a timeout would normally be) then it may be a name/IP resolution issue.  If the client cannot resolve the server IP then...

Great!  If you find that your tree gets more than 3 levels, or a dynamic depth above three, you can use the other techniques to drill down a hierarchical data...

Depending on what you need from the results, you might review a technique like this one:

http://www.geekzilla.co.uk/View96264E4E-52EE-42BD-9494-2F33947A9063.htm

From your original post I can see how you stored the data, how would...