title: Dynamic sql variable issues need fixing
body: <p>I made the seemingly minor change of adding a 2nd variable to a stored procedure in sql server 2008 r2 that uses dynamic sql, and I'm getting a new error:</p>
  
  <pre><code>Msg 206, Level 16, State 2, Line 1
  Operand type clash: date is incompatible with int
  </code></pre>
  
  <p>when I run the next code block below (the one following that is my sproc)</p>
  
  <pre><code>DECLARE @tableName varchar(120)
  SET @tableName = 'tblDailySMA'
  DECLARE @mxDate DATE
  SET @mxDate = dbo.LatestDateWithPricingVolCountOver4k()
  EXEC sprocAddDatesSymbolsAndPeriodsToAggregatedStudy @tableName, @mxDate
  
  USE [Market]
  GO
  /****** Object:  StoredProcedure [dbo].[sprocAddDatesSymbolsAndPeriodsToAggregatedStudy]    Script Date: 03/11/2012 12:55:13 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  ALTER PROCEDURE [dbo].[sprocAddDatesSymbolsAndPeriodsToAggregatedStudy]
      @table varchar(120), @maxDate DATE
  
  AS
  
  EXEC(
      ';WITH t1 AS
      (
          SELECT Symbol, TradingDate
          FROM tblSymbolsMain
          CROSS JOIN tblTradingDays
          WHERE TradingDate &lt;=' + @maxDate +
      '), 
  
      t2 AS
      (
          SELECT Symbol, TradingDate, Period
          FROM t1
          CROSS JOIN tblPeriods
      )
  
      INSERT INTO ' + @table + ' (Symbol, TradeDate, Period)
      (SELECT Symbol, TradingDate, Period
      FROM t2
      EXCEPT
          (SELECT t3.Symbol, t3.TradeDate, t3.Period
           FROM ' + @table + '))')
  
  RETURN
  </code></pre>
  
  <p>I'm sure it's a very simple quick fix, what am I overlooking? Thanks in advance.</p>