AnsweredAssumed Answered

How to create a comma separated list from a query.

Question asked by Felipe.Hernandez.Orasi on Sep 8, 2016
Latest reply on Sep 9, 2016 by Kenneth_Avery

Hi All,

 

I'm trying to generate a string from the values extracted from a database.

I have this query: 

SELECT TOP 5 ID FROM DBO.TestMart_PROD_ORD WHERE DBLocation='nopcomm' ORDER BY QUANTITYSOLD DESC

Which will bring me the 5 best selling articles from my webstore, but I what to use it as an input for another query so I need them in the format of (1,2,3,4,5). I've tried with the replace formula to indicate that instead of the <CR><LF> uses the ',' but it didn't work because on how the query is responding.

Anyone could have any idea on how to solve this?

 

Regards,

Felipe A. Hernandez.

Outcomes