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 |
|
JTProg
Starting Member
24 Posts |
 Posted - 2006-12-20 : 15:43:47
|
| Is there away of returning the many side of a relationship in one row and one column for related keys?Example:Table1Primary Key: TMIDTable2 Primary Key: FormIDForeign Key: TMIDI want my output to look like this:TMID FormID1 1,2, 3Instead of:TMID FormID1 11 21 3This will be used to display a datagrid in ASP.NET and I want to link from the Form ID, trying to keep all related in a batch. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-20 : 22:26:06
|
| Check this discussion:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53293[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Query