display multiple rows into one value
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: display multiple rows into one value

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    display multiple rows into one value

    Hello

    was wondering is there a way to multiple values of a order into one row



    Code:
    currently if i do select * from order_code_placed, i get the following
    
    orderid	code	ord_seq
    345901	33	1
    345901	75	2
    345901	88	3
    345901	101	4
    345901	114	5
    345901	127	6
    345901	33	7
    345901	75	8
    345901	33	9
    345901	75	10
    345901	33	11
    345901	75	12
    345902	16	1
    345902	45	2
    345902	74	3
    345902	103	4
    345902	132	5
    345902	77	6
    345902	44	7
    345902	52	8
    345902	32	9
    		
    but would like to display like this,is this possible.
    		
    orderid	code	
    
    345901	33,75,88,101,114,127,33,75,33,75,33,75	
    345902	16,45,74,103,132,77 ,44 ,52 ,32
    any help is much appreciated.thanks much

  2. #2
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    was too quick to post ..never mind i got it with xmlagg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width