title: What is the error The data types varchar and datetime2 are incompatible in the add operator
body: <pre><code>DECLARE @State VARCHAR(32) =NULL,
          @Industry varchar(128)= NULL,
          @ListSource varchar(128) = NULL,
          @TimeZone VARCHAR(30) =NULL
  DECLARE @Today DATETIME
  SET     @Today = GETDATE() 
  DECLARE @sSQL NVARCHAR(3000)
  SET @State=1
  SET @Industry=1
  SET @ListSource=1
  SET @TimeZone=5
  SET @sSQL = 
  'SELECT top 20 p.ID'+ 
  CHAR(10) +'from dbo.Prospects P WITH (NOLOCK)'+ CHAR(10) +
  'where p.State=ISNULL('+ CHAR(39)+@State +CHAR(39)+','+'p.State)'+ CHAR(10) +
  'AND p.Industry ='+@Industry + CHAR(10) +'AND p.ListSource='+@ListSource+ CHAR(10) +'
  AND p.StatusID not in(-1,2,4,5,6,7,8,9,12,13,14)'+ CHAR(10) +'
  AND isnull(p.PushDate,'+CHAR(39)+'1/1/1900'+CHAR(39)+')&lt;='+CHAR(39)+@Today+CHAR(39)+
  CHAR(10) +'AND p.TimeZone ='+@TimeZone+ CHAR(10) +'
  order by isnull(p.LastActivityDate,'+CHAR(39)+'1/1/1900'+CHAR(39)+')'
  </code></pre>