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 2000 Forums

Transact-SQL (2000)

Query

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-04-13 : 11:53:33

Hi all,

I have the table like

Seekid CFGID
135 14
135 23
135 37
135 25
. .
. .
. .
. .
135 30

I want the CFGID like '14','23','37','25','30' for the coresponding Seekid 135. How can i do this. Please help me
Thnaks
Krishna

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-13 : 11:57:12

have a look at the articles here: http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx

warning: In case you are new to sql server, the "10 things I hate..." article is a joke.

www.elsasoft.org

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-04-13 : 12:12:30

Hi Jeze, Thanks for your response. I dont want to cross tab. I just want to concat the result returned by CFGID.

Thnaks

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-13 : 12:18:27

Look here: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64079&SearchTerms=concatenate,records[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-04-13 : 12:28:02

Hi Harsh, Thanks I got it

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-04-13 : 12:44:26

Where do you want to show concatenated data?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources