I am looking to export data from SQL to an external program. Currently we have a table setup to take answers to some questions. Some of these questions require multiple answers, therefore creating another row within the table. I would like to identify these multiple rows from the same question and insert the answers into one common column for exporting as the external program has only one field for the answers. Hope this make sense.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple Rows one Column
- Thread starter chester27
- Start date
Take a look at this thread:
thread183-1159740
Hope it helps,
Alex
[small]----signature below----[/small]
Numbers is hardly real and they never have feelings but you push too hard, even numbers got limits
Why did one straw break the camel's back? Here's the secret: the million other straws underneath it
My Crummy Web Page
thread183-1159740
Hope it helps,
Alex
[small]----signature below----[/small]
Numbers is hardly real and they never have feelings but you push too hard, even numbers got limits
Why did one straw break the camel's back? Here's the secret: the million other straws underneath it
My Crummy Web Page
- Status
Similar threads
- Locked
- Question
- Locked
- Question