Hi,
i am trying to pass some values from a choice multiple into an sql executor as a published parameter ('$(Name)'). I can get it to work by using something like this but its not very efficient.
select Name
from Nametable
where
'$(Name)' LIKE '%'+ columnName +'%'
i have done this manually: where columnName in (Andrew, David)
It works alot faster than the above but i cant get it to populate and run from the published parameter.
this wont work columnName = '$(Name)' as it translates into
columnName = 'Andrew David' so there will never be a match as the name in column will be Andrew or David.
Any help or pointers would be appreciated.
Thanks,
Andrew