Tranposing pivoting minimums using sql arrays %let pgm=utl-transposing-pivoting-minimums-using-sql-arrays; Transposing pivoting minimums using sql arrays GitHub https ...

I realize there is a simple non SQL solution, however this is a pure sql solution. It may not be as slow as you think. This is the case where you do not have column names in your input table SAS does ...

Let's say I have a query I'm running in MS SQL Server 2k that returns this result set:<BR>-----<BR>MSFT 2002-01-31 63.71000000<BR>MSFT 2002-02-28 58.34000000<BR>MSFT 2002-03-31 60.31000000<BR>MSFT ...