title: Stored Procedure with multi value parameter behaving strangely
body: <p>I created a stored procedure in sql server to feed SSRS to allow it to accept Multiple values. 
  I have created it and when I used it in my report or execute it in sql server I have the following error message. Is there anything i am missing? Thanks</p>
  
  <pre><code>Msg 207, Level 16, State 1, Line 35
  Invalid column name 'London'.
  </code></pre>
  
  <p>This is my sample data. feel free to create table with it</p>
  
  <pre><code>DECLARE @MyTables AS TABLE (ID INT, City VARCHAR(100))
  INSERT INTO @MyTables VALUES
  (1,'London'),
  (2,'Chester'),
  (3,'Luton'),
  (4,'New York'),
  (1,'London'),
  (2,'Chester'),
  (5,'Paris'),
  (5,'Paris'),
  (2,'Chester'),
  (2,'Chester')
  SELECT * FROM @MyTables
  </code></pre>
  
  <p>This is my code for the dynamic stores procedure</p>
  
  <pre><code>CREATE PROCEDURE dbo.CitiesGroup
          @Cities NVARCHAR(Max) -- this are the parameters
      AS
      BEGIN
      DECLARE @sqLQuery VARCHAR(MAX)
      Declare @AnswersTempTable Table
      (  ID  INT,
         City VARCHAR(250)
      )
  SET @sqlQuery =
      'SELECT  
      ID,
      City
  FROM MyTables
  where Convert(nvarchar(Max),City) IN ('+@Cities+')
  Insert into @AnswersTempTable
  exec (@sqlQuery)
  select * from @AnswersTempTable'
  END
  </code></pre>
  
  <p>Thanks </p>
  
  <pre><code>EXEC dbo.CitiesGroup 'London'
  </code></pre>
  
  <p>Error meg</p>
  
  <pre><code>Msg 207, Level 16, State 1, Line 32
  Invalid column name 'London'.
  </code></pre>