Output 1-many records to 1 line per parent
-
Here is a picture of what the data looks like in a 1-to-many relationship, and how it needs to be displayed:
Any suggestions on how to accomplish this would be appreciated.
-
Lookup PIVOT in BOL. It will get you part way.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply