Multi Rows to Single Row - 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

Development Tools

Reporting Services Development

Multi Rows to Single Row

Author

Topic

bo0tl3ss
Starting Member

20 Posts

Posted - 2010-10-04 : 00:04:29

Hi, Good day!

I have this dataset on the report.


rows

1 The
2 Quick
3 Brown
4 Fox
5 Jumps

how can i show it to a single line?


The, Quick, Brow, Fox, Jumps

thanks in advanced!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-10-04 : 10:07:31

see scenario 3

http://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

bo0tl3ss
Starting Member

20 Posts

Posted - 2010-10-04 : 23:12:21

quote:
Originally posted by visakh16

see scenario 3

http://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

hi thank you.

but this one is thru SP. im looking using report services. i need it both. by row and a single line.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources