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?
Felipe A. Hernandez.