title: XML data type method “value” must be a string literal
body: <p>How to change my  query so that this error doesn't happen:</p>
  
  <blockquote>
    <p>XML data type method “value” must be a string literal</p>
  </blockquote>
  
  <p>T-SQL code:</p>
  
  <pre><code>Declare @Count Int = 1 
  While(@count &lt;= @j) 
  Begin 
  insert into mytable 
  ([Word]) 
  Select ([XmlColumn].value(N'word['+Cast(@Count as nvarchar(2))+']/@Entry','nvarchar(max)')) 
      from OtherTable WHERE ID=2
  </code></pre>