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.
| Author |
Topic |
|
yapafly
Starting Member
6 Posts |
 Posted - 2008-06-05 : 00:23:18
|
Hi, All..I hope someone can help me...I'm newbie in SSRS..My Problem is:I have generated a table like below:quote:
Customer_ID ---- Item_in_cart=============================== 12ab --------------- bag_123 12ab --------------- bag_122 13ac --------------- bag_007
But i hope my table that be generated can like this:quote:
Customer_ID ---- Item_in_cart=============================== 12ab --------------- bag_123, bag_122 13ac --------------- bag_007
so i not sure in visual studio can do it or not..sadhere is my sql code: quote:
select Customer_ID, Item_in_cartfrom Customer_cart
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-05 : 01:47:12
|
| Are you using SQL 2005? |
 |
|
|
yapafly
Starting Member
6 Posts |
Posted - 2008-06-05 : 02:01:39
|
| i using visual studio 2005...oracle database...any idea to solve it..? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-05 : 02:17:04
|
| http://www.oracle.com/technology/oramag/code/tips2006/101606.html |
|
|
|
yapafly
Starting Member
6 Posts |
Posted - 2008-06-05 : 02:46:54
|
| visakh,ur link is not work...:(any other idea..? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-05 : 03:29:54
|
| Did you try bring the data in the reqmnd format from oracle table using the method suggested in link? |
|
|
|
yapafly
Starting Member
6 Posts |
Posted - 2008-06-05 : 03:56:17
|
| sorry, visakhi means ur link cannot be open...so sorry.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 01:37:54
|
quote:
Originally posted by yapafly
sorry, visakhi means ur link cannot be open...so sorry..
its working for me though |
|
|
|
yapafly
Starting Member
6 Posts |
Posted - 2008-06-10 : 02:25:39
|
Thanks All, now its work via this method.quote:
select deptno, substr(SYS_CONNECT_BY_PATH(lname, ','),2) name_listfrom ( select lname, deptno, count(*) OVER ( partition by deptno ) cnt, ROW_NUMBER () OVER ( partition by deptno order by lname) seq from igribun.emp where deptno is not null)where seq=cntstart with seq=1connect by prior seq+1=seqand prior deptno=deptno;
|
|
|
|
|
|
|
|
|
Table Problem