Pivot as microsoft have developed it is dynamic. It has to be because it needs to create a list of the fields. You don't see this But it is there....

Thank you Jeff for looking at the code and I like your solution.

This is Old code and is just an example that code interface was driven from within Excel with...

I wear one cap for Creating, Changing and Updating Data which should be rigorious documented and regulated.

However businesses need to be flexible over analysis, presentation and using the rich data...

Right haven't had time to check run this and its old code but the purpose is to show an elegant solution to what as originally coded was awful and bug...

The use of temporary Procs. Of course these are written is TSQL but there purpose is to reduce complexity and at the same time handle specialised and particular sessions.

I understand...

You still don't get it. It is to simplfy and actually make the logic simpler.

In serious code the level of duplication and associated complexity becomes absurb especially when dealing...

Why would you want to write billions of lines of Exec Code?

Decoding that is utter madness.

Used carefuly and thoughtfully it avoids precisely sphagetti Code and supplies a simply elegant solution.

Especially...

I have used temporary Stored Procs for many years with XML and inline code they are a very elegant wen used with temporary tables

I have successfully used temporary Stored Procs for Years.

They are very powerful features.

I simply use XML.

Using XML whole complex structures can be passed to SQL and treated as Tables.

You can use Functions with the XML to render these into virtual tables...

Its an interesting chat.

My use of XML here has been to actually enable the Server to apply various or even alternative business rules logic to an Application even to the...

Hi

I have actually been doing this for years.

But going much further because of my C++ background

Because XML will integrate better with classes including apparent inheritance.

Controling front end business...