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

SQL Server Development (2000)

query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-31 : 22:51:52

Govind writes "hi,

I have composite primary key in the table.
for eg., entry is like this

field1         field2
one            one 
one            two 
one            three
two            one1
two            two1
two            three1

the result set should look like this

one one,two,three
two one1,two1,three1

based on the field1 value the values of fields2 should be shown .

should be achieved with a query only. no usage of cursors.

how to achieve the above in sql server

thanks in advance
Govind"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-31 : 22:51:52

Always a good idea to search the site (http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources