Using Sybase ASE 12.5.4 and looking to list / concat string values

Question

I have a table that looks like this

enter image description here

I want to create a query so that same values of column 1 and column 2 (tcbname and status) are grouped and column 3 (scope_name) lists all the scopes related to that status and tcb_name.

Below is my expected outcome

| TUVAmerica, inc | | E | |<all the scope_name values that match first two column>|

@ZaynulAbadinTuhin I have shared the expected result in my above question. — A boy has no name, Oct 19 '18 at 15:05
@HartCO I have tried so many things but nothing seems to be working at this point. — A boy has no name, Oct 19 '18 at 15:08
Not exactly sure but its prior to 2008, it does not have Group_Concat nor Separator funtions — A boy has no name, Oct 19 '18 at 15:24
It does not look like that you are using MySQL. you might be using SQL Server ! — Madhur Bhaiya, Oct 19 '18 at 15:26
which Sybase product (ASE, SQLAnywhere, IQ, Advantage) and version? the question has now been tagged as sybase-ase, but ASE never had versions based on years (ie, '2008' is not a valid ASE version) so I'm wondering if this is Microsoft SQL Server? — markp-fuso, Oct 19 '18 at 19:55
@markp is there a way we could concat or LIST the string in one column in Sybase ASE 12.5.4? — A boy has no name, Nov 08 '18 at 20:42
@Aboyhasnoname for ASE 12.5.4 you're probably looking at having to write some T-SQL code (SQL batch; stored proc) to perform the concatenation; what do you plan on doing with the concatenated value ... send to client application? write to a table? — markp-fuso, Nov 08 '18 at 22:01
@markp I am pulling data out of Sybase to Servicenow. It requires data massaging so that's why I need to concatenate these values. — A boy has no name, Nov 09 '18 at 20:17

score 1 · Answer 1 · answered Oct 19 '18 at 15:07

1

It seems to me you need group_concat()

 select tcb_name ,status,
 group_concat(scope_name separator ',') as list_of_scope
 from your_table
 group by tcb_name,status

answered Oct 19 '18 at 15:07

Zaynul Abadin Tuhin

31,407
5
33
63

Using Sybase ASE 12.5.4 and looking to list / concat string values

1 Answers1