title: Stored Procedure with multi value parameter
body: <p>I am trying to create a stored procedure which will accept multi value parameter for the where condition like below</p>
  
  <pre><code>ALTER PROC spGetExpectedSalesOrActiveSales @Divisions NVARCHAR(200), @var1 int
  AS
  BEGIN
      SELECT *
      FROM ABC
      WHERE x = '0' and z=@var1 
          AND y IN (@Divisions) 
  
  END
  exec spGetExpectedSalesOrActiveSales 'EE, MM' ,1
  </code></pre>
  
  <p>In-place of @Divisions if I use 'ABC' or 'ABC,XYZ' then its working good and 
  when I am passing a single value through the API for the @Divisions then its executing that but when passing more than one value like 'ABC, XYX' then its simply displaying no records.
  The values I am passing through my API, its an array of string.
  I am not taking the @Divisions values from a query but from the API.</p>