Combine multiple records into single row
- From: "franzey" <franzey@xxxxxxxxx>
- Date: 29 Mar 2007 09:43:08 -0700
This is how the data is organized:
vID Answer
12 Satisfied
12 Marketing
12 Yes
15 Dissatisfied
15 Technology
15 No
32 Strongly Dissatisfied
32 Marketing
32 Yes
What I need to do is pull a recordset which each vID is a single row
and each of the answers is a different field in the row so it looks
something like this
vID Answer1 Answer2 Answer3
12 Saitsfied Marketing Yes
etc...
I can't quite get my mind wrapped around this one.
.
- Follow-Ups:
- Re: Combine multiple records into single row
- From: --CELKO--
- Re: Combine multiple records into single row
- From: Jason Lepack
- Re: Combine multiple records into single row
- Prev by Date: SSIS PAckage Hangs
- Next by Date: Re: Combine multiple records into single row
- Previous by thread: SSIS PAckage Hangs
- Next by thread: Re: Combine multiple records into single row
- Index(es):