This going back and forth is completely meaningless.

Post a full DDL and a listing of SPT, and what you're looking to generate.....IOW, give me a schema, your end result, and all relevant SQL code to go from DDL all the way to result set. If you want to post the code for that doctor's appointment result set that you talked about months ago, go ahead and post that.

If you can populate some data, and make it available to me, that would be better. Basically, I need whatever it would take to run on my machine, to go from DLL to final result set.

So long as I don't have to spend a ton of time going through 10 pages of listings, I'll see about posting an equivalent or very comparable solution in .NET/SQL. It may take me a few days, might even take a week or more...and in the meantime, all other dialog on this ceases.

If I have to sign an NDA that I won't share the contents of the data, fine. [If I ever wanted to use the schema itself and the queries that I might write, as part of either a writing project or presentation, I'd have the right to, so don't post any schema that's considered intellectual property or a trade secret].


Kevin