Well Jeff, if you look at the problem in a real world situation with thousands of stocks and thousands of datapoints and thousands of accesses to those I would suggest...

May I suggest some improvements to the outlined solution.

First I would prefer to store the stock quotes as integers (multiply by 100) - less storage space needed which also transforms...

There is a minor bug in the procedure.

Input parameter is 'schema.Table' but the schema part is not used when selecting from information_schema.columns. It doesn't matter if you don't have the...

May I suggest this alternative solution. In my opinion more simple and more lean on i/o (4 logical reads vs 7).

select

...