View previous topic :: View next topic
|
Author |
Message |
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
Hi All,
My requirement is to Insert 10 rows in a Table at The same time.
Primary key Of the table is combinations of (Col,Col2) Currently table is having 10 Rows with Col1 = 'A' and Different values for COl2.
My requiremnt is to replicate all above 10 rows only with changed values for Col1. Means a new set of rows with COl1 = 'B' keeping all other data similar.
Currently I am selecting the data in cursor, changing the value of Col1 and again inseritng into table
I will be very thankful if anyone guides me to any other more efficient way for this requirement
Thanks in Advance
Regards,
Chandan |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
Thanks Dick..It's working fine
I would have tried this..I will take care henceforth.. |
|
Back to top |
|
|
|