Multiple rows ins single row with row delimiter

Asked Apr 04 '17 at 01:45

Active Apr 04 '17 at 04:54

Viewed 132 times

I have this table:

CID CNAME ADDRESS
------------------
100 ABC   ABCD
200 DEF   DSDFD

I need to export the data from this table to file in this single row. This is what I want..

100 ABC ABCD  200 DEF DSDFD

I am using SAP HANA database. I have tried multiple options but not able to produce the format I want. Appreciate your help!!

Thank you..

edited Apr 04 '17 at 04:54

marc_s

asked Apr 04 '17 at 01:45

user138770

does hana support STUFF? – RoMEoMusTDiE Apr 04 '17 at 01:57
duplicate of this case http://stackoverflow.com/questions/26673458/how-to-concatenate-multiple-rows-fields-in-a-sap-hana-table – RoMEoMusTDiE Apr 04 '17 at 01:58
Thank you for your reply. No HANA doesn't support STUFF. – user138770 Apr 04 '17 at 13:43

0 Answers0