title: SQL IDENTITIY Column not starting with 1
body: <p>I have a temp table in SQL 2014.  In this table variable I have an identity column declared.</p>
  
  <pre><code>DECLARE  @TempTable TABLE
  (
      ID int IDENTITY(1,1) PRIMARY KEY
      , IncidentResolvedOn date
      , IncidentCreatedOn date
      , IncidentClosedOn date
      , TaskAssigned date
      , TaskCompleted date
      , TaskID float
      , IncidentTeamID int
      , TotalDaysOutstanding int
      , TierInfo varchar(15)
      , Task_NoTask varchar(15)
      , Tier_2_Days_Outstanding int
      , Tier_1_Days_Outstanding int
      , DaysToResolve int
      , BadDays int
      , StartDate date
      , EndDate date
  ) 
  </code></pre>
  
  <p>When I run the rest of the query the ID column sometimes doesn't start with 1, instead it starts with some random number.  The code below is what I use to insert into this table variable. </p>
  
  <pre><code>INSERT INTO @TempTable(IncidentResolvedOn, IncidentCreatedOn, IncidentClosedOn,TaskAssigned, TaskCompleted, TaskID, IncidentTeamID )
  SELECT  [Incident Resolved On]
          , [Incident Created On]
          , [Incident Closed On]
          , [Task Assigned On]
          , [Task Completed On]
          , [Task ID]
          , IncidentTeamID
  
  FROM HEATData
  </code></pre>
  
  <p>This happens in both a table variable and temp table.  I've never seen this happen before.  Usually when I use the IDENTITY(1,1) phrase it always starts with 1 no matter how many times I create that table.  Any suggestions out there?</p>