I'm trying to pass a parameter value to the sql query like described in the KB article. Sample:
SELECT * FROM Person.Contact WHERE FirstName = @FirstName
This works fine, but if I try with a multi valued parameter, the query gives no results:
SELECT * FROM Person.Contact WHERE FirstName IN (@FirstName)
Any ideas? Thanks in advance.