title: Cannot resolve the collation conflict between "Latin1_General_BIN" and "Latin1_General_CI_AS" in the equal to operation
body: <pre><code>I am getting the following error 
  </code></pre>
  
  <blockquote>
    <p>Cannot resolve the collation conflict between "Latin1_General_BIN" and
    "Latin1_General_CI_AS" in the equal to operation.</p>
  </blockquote>
  
  <p>Code</p>
  
  <pre><code>SELECT @PARTS = SUM(Llines_1.[qty]) from pick 
  RIGHT OUTER JOIN op AS Llines_1 ON pick.picknote = 
  Llines_1.[order_no] WHERE (pick.batchid = @batchid) AND (product = @product)
  group by product Order By product
  </code></pre>
  
  <p>I have tired using COLLATE SQL_Latin1_General_CP1_CI_AS  before the from but still get the same error.</p>
  
  <pre><code>SELECT @PARTS = SUM(Llines_1.[qty])  COLLATE SQL_Latin1_General_CP1_CI_AS
  from pick RIGHT OUTER JOIN op AS Llines_1 ON pick.picknote = Llines_1.
  [order_no] WHERE (pick.batchid = @batchid) 
  AND (product = @product) group by product Order By product
  </code></pre>