title: Select IN on more than 2100 values
body: <p>How can you do a select in on more than 2100 values?</p>
  
  <pre><code>&lt;cfquery name="result.qryData"&gt;
    SELECT    sub_acct_no,  ...
    FROM  dbo.Closed_ORDER
    WHERE ord_no IN &lt;cfqueryparam cfsqltype="CF_SQL_varchar" value="#ValueList(qryOrd.ord_no)#" list="yes"&gt;
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>Because of the ways that the tables are setup, linked Servers and JOINS are not an option.</p>
  
  <p>When this is ran an error this thrown because there are new many fields being passed in.</p>