Re: Sorting multiple rows

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Wed, 09 Jan 2002 21:10:10 +0000
Message-ID: <3C3CB1B2.FEE2EB76@exesolutions.com>

The only way to accomplish this is to write a proc that parses the strings and loads the results into a table from which you can query. Shouldn't be more than an hour or two's worth of work.

Daniel Morgan

Ryn wrote:

> Hello folks,
>
> I have hundreds of rows of data in a format simialr to:
>
> column 1 - column 7
> 2001-12-05, 12, 34, 06, 56, 33, 98
> 1999-09-03, 01, 06, 34, 57, 23, 12
> .
> .
> .
> I need to select column 2 - column 7 and print something similar to:
>
> 12: 6 entries
> 34: 3 entries
> 23: 2 entries
> 01: 2 entries
> 08: 1 entries
> 55: 1 entries
>
> I have been parsing through the SQL documentation and cannot find an
> example that does something similar. Does anyone have an example they
> could share?
>
> Thanks,
>
> - Ryan
Received on Wed Jan 09 2002 - 15:10:10 CST