You are here: Help with combining data from multiple rows into one column in a view « MsSQL Server « IT news, forums, messages
Help with combining data from multiple rows into one column in a view

Posted by gaholmes on 07/19/07 17:37

Hi, I am stumped and was hoping someone could help me out. Any help is
appreciated.


I have a view that looks sort of like this (but with a lot more
entries of course)


UniqueIdentifyier Column1 Column2
1 9999 100
2 9999 200
3 9999 300


What I want to do is to add a column to the view that will contain a
list of the values from column 2 where column 1 is the same.

UniqueIdentifyier Column1 Column2 Column3
1 9999 100 100, 200, 300
2 9999 200 100, 200, 300
3 9999 300 100, 200, 300

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация