Converting Rows To one Column - 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)

Converting Rows To one Column

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-18 : 09:15:33

Zainul writes "Let consider a table like

Custid         AcctNum
------         --------
1019           10199835
1019           10194674
1023           10238475
1023           10237556
1017           10175555

is it possible to see this data as

CustID         Acct_NumberS
------         ----------------------------------
1019           10199835,10194674
1023           10238475,10237556
1017           10175555

shankarc
Starting Member

37 Posts

Posted - 2001-12-18 : 09:23:09

In addition to that search for Cross tab reports in SQL Server Books online

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources