title: Issues publishing my stored procedure to azure - The data types time and datetime are incompatible in the add operator
body: <p>I am trying to publish my app to azure, but I got the error below</p>
  <blockquote>
  <p>The data types time and datetime are incompatible in the add operator.</p>
  </blockquote>
  <p>This is strange because on my computer my app works perfectly fine no error messages related to the date datetime operator.</p>
  <p>my stored procedure is below,
  Any help to find the issue will be greatly appreciate.
  Thanks...!!!</p>
  <pre><code>    @Tenant int, @UnitId int
  AS
  
  DECLARE @LeaseExp as Date
  DECLARE @Address as nvarchar(50)
  DECLARE @Address1 as nvarchar(50)
  DECLARE @SubjectLeaseExpire as nvarchar(255)
  
  DECLARE @TIMESTART TIME = '09:00:00'
  DECLARE @TIMEEND TIME = '09:15:00'
  DECLARE @DATETIMEstart DATETIME
  DECLARE @DATETIMEend DATETIME  
  
  
  Begin
  SELECT      @LeaseExp = Lease.LEAEnd, @Address = Units.UNIAddress, @Address1 = Units.UNIAddress1
  FROM          Lease 
  INNER JOIN Units ON Lease.LEAUnitId = Units.UNIId
  
  WHERE         Lease.LEAUnitId = @UnitId and Lease.LEAId = @Tenant
  
  DECLARE @DATETIME DATETIME = @LeaseExp
  
  SET @DATETIMEstart = @TIMESTART+@DATETIME
  SET @DATETIMEEND = @TIMEEND+@DATETIME
  
  SET @SubjectLeaseExpire ='Lease will not be renewed modify Occupancy on the Unit: '+ @Address + @Address1 +' and Terminate Tenant in the system'
  
  insert into Calendar(Start, Finish, Subject)
  Values (@DATETIMEstart, @DATETIMEEND, @SubjectLeaseExpire)
  
  End
  </code></pre>