×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Very cool! Glad to have found something that adds to our knowledge.
Vern
On Thu, 14 Mar, 2024 at 8:43 AM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
To: midrange systems technical discussion
Thanks Vern... That is a great explanation.
I did it this way... but I didn't need to use the ROW_NUMBER() over (PARTITION BY) because my table already contains a unique sequence number within the "partition".
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of VERNON HAMBERG Owner via MIDRANGE-L
Sent: Wednesday, March 13, 2024 7:07 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx<mailto:vhamberg@xxxxxxxxxxxxxxx>>; midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL rows to columns
Looks like Kent Milligan wrote this article - one of the IBM database people, article looks very well laid out. Example is a bit simpler than what is asked for here, but can extended pretty easily.
Regards
Vern
On Wed, 13 Mar, 2024 at 1:59 PM, Glenn Gundermann <glenn.gundermann@xxxxxxxxx<mailto:glenn.gundermann@xxxxxxxxx>> wrote:
To: midrange systems technical discussion
I don't know if this helps but this article's title mentions pivot.
https://db2ibmi.blogspot.com/2023/07/pivoting-with-sql.html
Yours truly,
Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx<mailto:glenn.gundermann@xxxxxxxxx><mailto:glenn.gundermann@xxxxxxxxx<mailto:glenn.gundermann@xxxxxxxxx>>
Cell: (416) 317-3144
midrange.com
