Re: Use SQL to give me one record from many

Busy, but I think what you are looking for is called a "pivot table".


Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Alan Shore <ashore@xxxxxxxx>
To: "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
Date: 06/07/2011 01:58 PM
Subject: Use SQL to give me one record from many
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Hi everyone
Here is my predicament
I have one file with 2 fields, for example
Field 1 Field 2
A 100
A 150
A 161
B 007
C 005
C 001
C 017
C 999
Etc.
I need to provide the following result in a different file
Field 1 Field 2 Field 3 Field 4 etc.
A 100 150 161
B 007
C 001 005 017
999
And so on
I am sure that I have seen some e-mails about this in the past, and I have
tried looking for them, but I am not even too sure what the correct key
words should be
So - if anyone can point me in the correct direction, as always, all
responses MUCH appreciated

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.