Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:20:11
|
| Kevin writes "I am working from a mainframe database that copies its tables into our SQL server 7.0 on a Windows 2000 server. As a result of originating from a mainframe, the description field for each record is a maximum of 70 characters. This means that we have multiple rows with the same productID so that we can hold the description.Is there a way to create a view that copies all the descriptions into a single field in a record where the productID would become the primary key?Thanks,Confounded in Calgary" |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-06-10 : 09:04:09
|
| You can review this link and it might help you generate some ideas.http://www.sqlteam.com/item.asp?ItemID=2368 |
 |
|
|
|
|
|
Concatenate Fields From Multiple Rows