Modified query result - 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)

Modified query result

Author

Topic

vguptais
Starting Member

8 Posts

Posted - 2007-09-21 : 04:14:58

Hello,

I wonder if somebody can help me. I have a table like
COMPRESSION FITTINGS COM
COMPRESSION FITTINGS BRAS
COMPRESSION FITTINGS STAIN
COMPRESSION FITTINGS BRAS
COMPRESSION FITTINGS MISCE
COMPRESSION FITTINGS DOUBL
COMPRESSION FITTINGS DOUBL
INSTANT FITTINGS INSTA
INSTANT FITTINGS LF300
INSTANT FITTINGS LF380
INSTANT FITTINGS LF3400
INSTANT FITTINGS LF3000
INSTANT FITTINGS LF3600,

I want it to be in a format like

COMPRESSION FITTINGS COM,BRAS,STAIN,BRAS,MISC..
INSTANT FITTINGS INSTA,LF300,LF380,LF3400,LF3000

Please if somebody can help me.

Thanks
Vikrant Gupta

Kristen
Test

22859 Posts

Posted - 2007-09-21 : 04:17:37

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Cross-Tabs,Pivot+Tables,CrossTabs

Kristen

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-21 : 04:26:31

1 If you use front end application, do concatenation there
2 http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources