Increment question

• Dave Bailey

  SSC Veteran

  Points: 216

  More actions

  November 10, 2005 at 9:04 am

  #169479

  I have the following snippet of code:

  select 'L' as RECTYPE, identity(int, 1, 1)as JELINENO, '800002' as JENO, 'AJE' as JECODE,

  '2006' as FY,

   

  I am saving this output into a #Temp table and after using the information I am dropping the table.  The questions is, is there a way to increment the JENO by 1 each time the process runs?

   

  Thanks,

   

  Dave

• November 14, 2005 at 8:00 am

  This was removed by the editor as SPAM

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  November 14, 2005 at 8:09 am

  #603687

  You could "SELECT MAX(JENO)" & add 1 to it...

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• Dave Bailey

  SSC Veteran

  Points: 216

  More actions

  November 14, 2005 at 8:21 am

  #603690

  I figured this out.  The answers is:

   

  (select max(JENO) + 1 from issuesreturns) as JENO,

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  November 14, 2005 at 8:34 am

  #603694

  right - except your alias 'JENO' would be after your select max(jeno) + 1...

  select (max(JENO) + 1) as JENO from issuesreturns

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• Don Hansen-228842

  Grasshopper

  Points: 11

  More actions

  November 14, 2005 at 6:38 pm

  #603798

  If you define your temp table just make the column in question an Identity column.

   

  CREATE TABLE #temp Col1 int IDENTITY(1,1), col2 <datatype>...

   

  Then just dont include this column in your insert list.