Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
girish.gb19
Starting Member
1 Post |
 Posted - 2010-10-12 : 23:28:29
|
| I want to generate the row number for the following entries in the table as shown below100 1100 1101 2165 3100 4100 4100 4165 5165 5165 5165 5i.e., i want to generate the different row number for the consecutive same entries in the table I would appreciate & thankful for the sooner repliesThanks in AdvanceGB |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2010-10-12 : 23:33:51
|
| You are going to need some other columns in your table that establishes the sequence of the rows. You can't know what are "consecutive" rows without some other column or columns to ORDER BY.Be One with the OptimizerTG |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
row number