Comma Separated List

[link9]

Hello all --

Before I go spending too much time programming a solution for this, I was wondering if there's a SQL solution...

Let's say I have a table that looks like this:

SVP VPO
52 1
52 1
52 2
52 2

My end product for my app needs to be a comma separated list of VPOs that have SVP=52 (i.e. 1,2)

So if I ask:
SELECT VPO FROM table WHERE SVP = 52 GROUP BY VPO

then I get:
1
2

Is there a way I can get:
1,2

??

SQL Server is my DBMS, if that helps at all.

Thanks!
paul

 

[PruSQLer]

If you don't have too many varieties for VPO within SVP, this method might work:

Select SVP,
Max(case when VPO = 1 then 1 else 0 end),
Max(case when VPO = 2 then 2 else 0 end),
Max(case when VPO = 3 then 3 else 0 end),
ETC. {for as many as you need}
From Table
Group by SVP

If your DBMS returns CSV files, the output is fine. If not, you'll have to put commas in. I've done this with up to 35 values for my comparable SVP column.

 

[link9]

mmmm... yes, but then if anything in your table changes, then you have to go through and update every single instance of such statements. :-(

I'm thinking I'll just get my result set and parse it with code. Less maintenance, and not terribly inefficient.

Thanks, though.
paul