467,915 Members | 1,454 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

put rows together and group by another column

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
  • viewed: 2386
Share:
2 Replies
ck9663
Expert 2GB
Trythis

Happy coding!

-- CK
Jan 26 '09 #2
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.

Similar topics

3 posts views Thread by Harry | last post: by
1 post views Thread by mlrehberg | last post: by
6 posts views Thread by Steve Jorgensen | last post: by
68 posts views Thread by Martin Joergensen | last post: by
5 posts views Thread by dale.zjc | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.