Running into problems when I pass -
MyVariable = 'One','Two','Three'
select a.system, count(b.[Name]) SystemCount
from [System] a
left join NameIndustry] b
on a.system = b.system
where b.industry in ([MyVariable])
group by a.system
order by a.system
Works as designed if 1 value but the multi value returns nothing except the standard expression of non-Boolean type near comma.
I have read a lot on possible solutions but having a hard time following them as I want to understand the meaning behind a solution and see if with the expansion of technology if the possible outcomes have shifted.
Any help would be appreciated.