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 |
|
somu_p
Starting Member
13 Posts |
 Posted - 2008-04-02 : 11:49:23
|
| Hi,I have two tables named Tab1 and Tab2. Both are identical in structure. The only diff is Tab2 has two more additional fields (FromDate and ToDate).The structure is like below :Col1Col2 (Date field)Col3Col4Also Tab 2 have Col5 (From Date)Col6 (To Date)Now I want to transfer some set of reocrds from Tab1 to Tab2. The additional Tab2 field (Col5 and Col6) values should be the minimum and maximum values of Tab1 date field for the current set.How to accomplish this? Kindly help me in this regard.ThanksSomu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 12:25:46
|
| You can use SSIS for this data transfer. Just map all the available five fields and use Derived column task to generate values for the other two fields. |
 |
|
|
|
|
|
Data Transfer from two identical tables.