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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-12 : 07:48:04
|
| Nick writes "How create a new field with a consecutieve number(1,2,..to returned rows) in a select statement? a/a existing field1 A2 B3 C" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-12 : 07:48:26
|
| Try these:http://www.sqlteam.com/searchresults.asp?SearchTerms=row+number |
 |
|
|
|
|
|
create a count field on "select.."