Concat string columns – SAP HANA
Concat string columns – SAP HANA: do you need to concat string columns in SAP HANA?
Try something like this:
create procedure concat_me (out itens nvarchar(200))
as begin
declare cursor C for SELECT OITM.”ItemName” from OITM;
itens := ”;
for R as C do
itens := :itens || R.”ItemName” || char(13) || ”;
end for;
select :itens as “Itens” from dummy;
end;
then you can use this procedure to take the result of the concat.
If it does not work or you need help, write me!
New NetWeaver Information at SAP.com
Very Helpfull