title: SSRS escapes single quote twice when checking several values from multivalue parameter
body: <p>I am using SSRS 2008 R2. And found situation which seems to me a bug.</p>
  
  <p>I have a shared dataset -</p>
  
  <pre><code>SELECT 'value1' AS Value
  UNION
  SELECT 'value''2'
  </code></pre>
  
  <p>I bind this DS to multivalue parameter. When I check only value'2 from multivalue drop down - I see that in SQL Profiler such parameter is passed</p>
  
  <pre><code>@Value=N'value''2' -- Two single quotes
  </code></pre>
  
  <p>When I check both values in profiler I see</p>
  
  <pre><code>@Value=N'value1,value''''2' -- Four single quotes
  </code></pre>
  
  <p>My Procedure treats first case correctly.</p>
  
  <p>It seems to me that escape happens twice - first for every value, second for whole string?</p>
  
  <p>Does anyone know the source of such behaviour, Thx in advance!</p>
  
  <p><a href="http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/58320892-82b0-4d05-b59f-a9da4e436323/#58320892-82b0-4d05-b59f-a9da4e436323" rel="nofollow">Here is the same thread on MS</a></p>