Forum Discussion
How to pass multiple values into single string in Store
Hi All, I am passing a list of string into my stored procedure as a single value For eg: my procedure name is fetch_value It has single parameter called product. Alter procedure fetch _...
Dhakshina25 , and how do you prefered to get it solve?
One way is to replace the comma with an other character, like the semicolon:
Set @product = substring ((
Select distinct ','+ REPLACE(product, ',', ';')
from main_table) T1
Order by 1
For xml path ('')),2,2000);- Thanks for your valuable time
I exactly need(,) in the middle because my database value has comma in it, if I replace with semicolon it will not give any results
