Dilberted

Singapore

google.com

Age: 36

I love stack exchange sites

Apr
15
awarded Autobiographer
Apr
15
awarded Supporter
Mar
23
comment Concat column values with comma as the separator
@Squirrel I agree, bad design, the front-end or the server is not under my control. All i can do is play around with the sql part to meet the requirement. :( sadly it does not seem like it is possible but i wanted to give it try by asking here
Mar
23
comment Concat column values with comma as the separator
The values are passed to the server from the user selected values. this is part of the application configuration where we can configure the data to be fetched from the sql server. So there is no code involved just configuring an sql query to be executed and resulted is passed to the UI.
Mar
23
comment Concat column values with comma as the separator
i have updated my question for the sake of clarity. There are somethings not under my control to change hence I am trying to leverage the bad design to meet a certain requirement. See the update section please.
Mar
23
revised Concat column values with comma as the separator
added 192 characters in body
Mar
23
revised Concat column values with comma as the separator
added 38 characters in body
Mar
23
comment Concat column values with comma as the separator
The place where the sql query is being built is part of the application that acts as the adaptor, so there is specific syntax that gives out parameters, so what i am trying to do is build up a csv with the parameters to be passed to a stored procedure. I know it is unusual requirement but i was wondering if there is a way to sort it out. The number of varchar values can vary and not fixed.
Mar
23
comment Concat column values with comma as the separator
Yup i am aware of that but for now this needs to be a workaround till we can do it in the application side.
Mar
23
comment Concat column values with comma as the separator
If it was so easy then i would not need to ask the question here :) what you have mentioned above will work if you know the values. I want to be build csv dynamically.
Mar
23
comment Concat column values with comma as the separator
well if that was an option, i would have loved it. Due to some limitations, i have to do this within sql. @Andy
Mar
23
asked Concat column values with comma as the separator
Mar
22
awarded Caucus
Mar
2
comment Yahoo Finance API Error
yup. it is fine. there are no issues.
Mar
2
answered Yahoo Finance API Error
Nov
22
awarded Constituent
Nov
18
awarded Caucus
Oct
26
revised What method to add in NearablesDemoActivity.java
grammar correction
Oct
21
answered Database for android login activity
Oct
15
comment Android runtime error with release version but not debug version
Glad it worked. Just posted this as an answer. Thanks
1 2 3 4 5