auto increment row noumber

• sukhoi971

  SSCarpal Tunnel

  Points: 4833

  More actions

  February 25, 2005 at 11:46 pm

  #67067

  how do i auto increment number starting from a particular range

   

  like 600

  then next should be

  price-range| no of shares

  600           |400

  601           |600

  602           |

  603          |

  604           |

  out put should be something like that

   

  <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

  *Sukhoi*[font="Arial Narrow"][/font]

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  February 26, 2005 at 6:13 am

  #544307

  refer this

  http://www.sqlservercentral.com/columnists/dasanka/findminmaxvaluesinaset.asp

  u can put rank + 600 ( I think , Sorry I could n't check)

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 28, 2005 at 2:15 am

  #544365

  Another one would be

  http://support.microsoft.com/default.aspx?scid=kb;en-us;186133

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• sukhoi971

  SSCarpal Tunnel

  Points: 4833

  More actions

  March 1, 2005 at 6:32 am

  #544582

  thanks man, this really looked impossible

  <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

  *Sukhoi*[font="Arial Narrow"][/font]

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  March 2, 2005 at 12:05 am

  #544772

  Thankx Frank,

  But then I need to change all the quires which is not posible. I have to chage the column id content

  Anyway Thankx for the idea

   

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• sukhoi971

  SSCarpal Tunnel

  Points: 4833

  More actions

  March 3, 2005 at 10:09 pm

  #545381

  thanks,thanks

  <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

  *Sukhoi*[font="Arial Narrow"][/font]