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 |
|
1821
Starting Member
18 Posts |
 Posted - 2008-04-14 : 15:11:35
|
| Hi, sorry for another newbie question but I was wondering if the following is possible:I have to take some information from a table which I have already created a query for. This information then has to be inserted into a new table but needs another column (not the promary key) with another unique custom identifer for each record in the format EX01 which is incremented by 1 for each record. I was wondering how is it possible to do this?My approach was to create a view and then insert the values form the view into the new table but I still have no idea how to do the unique identifer. Was the first part of my approach correct or have been wrong from the start?Thanks for any help. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-14 : 15:25:50
|
| Create an identity columjn on the table. This will be automatically incremented for each insert.You can find the value assigned via scope_identity().==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL server query logic