Need Query - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need Query

Author

Topic

naren_venkata@yahoo.com
Starting Member

3 Posts

Posted - 2008-08-12 : 23:52:27

Hi all i have two table one is TFMS_CONTRACT_PRICES
with following data.
itemnumber CONTRACTORID
1 40

And other table is TFMS_ACCESSORIES_MASTER with following data.
CONTRACTORID ACCESSORYNAME
40 TV
40 COMPUTER

I need the query to display data like below.
itemnumber Accessories
1 TV,COMPUTER

Just i took sample data.i have so many number of records like this.
Pls help me.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-12 : 23:58:01

see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

KH
[spoiler]Time is always against us[/spoiler]

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 00:15:36

http://www.projectdmx.com/tsql/rowconcatenate.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources