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 |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2011-12-12 : 15:07:54
|
| I want to update a field in a table with an ID number and I want it to start with 500. So each sequential row will be one higher.update cicmpyset ID = (?????) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2011-12-12 : 15:15:53
|
| This is SQL 2000. When I try that I get row_number is not a recognized function name. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2011-12-12 : 15:39:20
|
| I'm dealing with two databases that use the same program. Each were populated with customers. Now I'm trying to merge the two. Do there is an ID column. In both tables they both started at 1 and incremented each time a new customer was added. I need to take one of the tables and start with the highest number from the other and increment it. I'm not sure how I can use an Identity column for this? Can you explain further. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Update field w/ count starting with specific #