By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,412 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,412 IT Pros & Developers. It's quick & easy.

put rows together and group by another column

P: 20
Hi

Say i have 3 rows and 2 columns

clientid1, details1
clientid1, details2
clientid1, details3

how do i get this result

clientid1, details1 details2 details3

so basically group by client and then add the rows together into one row.

feels like there should be a function for it.

thanks
Jan 26 '09 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
Trythis

Happy coding!

-- CK
Jan 26 '09 #2

P: 20
ah yes, I have done pivots before.

Thanks
Jan 27 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.