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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2005-01-10 : 16:14:36
|
| I have a select that returns a group of numbers. I would like to add a row number to this set.current11111113333333555555577777779999999would like to do this:1 11111112 33333333 55555554 77777775 9999999How can I do this? |
|
|
Hippi
Yak Posting Veteran
63 Posts |
Posted - 2005-01-10 : 16:27:14
|
quote:
Originally posted by helpme
I have a select that returns a group of numbers. I would like to add a row number to this set.current11111113333333555555577777779999999would like to do this:1 11111112 33333333 55555554 77777775 9999999How can I do this?
Do a search for identity in this forum first, Tugggan has posted the solution for the same problem |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-01-10 : 18:24:02
|
| Can you provide a link? |
|
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-01-10 : 18:36:00
|
| this is similar to what I'm trying, but if I have the table create in it (includingthe row number column), it doesn't work. If I don't include the table create,I get results, but it obviously doesn't include the row number column which I need.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43864 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-01-10 : 19:03:18
|
| Thanks Tara |
|
|
|
|
|
|
row number