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 |
|
sqlslick
Yak Posting Veteran
83 Posts |
 Posted - 2009-09-11 : 15:59:50
|
| Dear forum,Does anybody know how to add a new record to a table based on some of the values of another record? Here is an example:Initial table:ITEM_NO | UM | QTY | PRICE123 | BX | 50 | 100If a record has a QTY > 1 (i.e. 50) then insert a new record.The new table will look like this:ITEM_NO | UM | QTY | PRICE123 | BX | 50 | 100123 | BX | 1 | 100Thank you in advanced! |
|
|
|
|
|
INSERT record based on another record