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 |
|
Maharisi
Starting Member
19 Posts |
 Posted - 2007-07-02 : 07:34:00
|
| I have table Employees which contains atributtes a ID, PersonNumber, Datefrom, DateTo and Credit. I need copy whole table to another normalization table. For ExampleRecords1, 111, 1.12.2006, 3.12.2006, 0002, 111, 4.12.2006, 7.12.2006, 0003, 111, 8.12.2006, 12.12.2006, 0014, 111, 13.12.2006, 16.12.2006, 000I need insert these records from Employees table to Normalization table like this =>1, 111, 1.12.2006, 7.12.2006, 0002, 111, 8.12.2006, 12.12.2006, 0013, 111, 13.12.2006, 16.12.2006, 000I do not how please help me.Thanks(moved to "New to SQL Server" forum) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-02 : 11:05:23
|
quote:
Originally posted by madhivanan
Refer thishttp://sqlteam.com/forums/topic.asp?TOPIC_ID=65290MadhivananFailing to plan is Planning to fail
I think this is not an appropriate reference. What OP wanted has nothing to do with CSV.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-02 : 11:11:10
|
Maharisi,Can you explain more on the criteria and condition for your grouping ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Please help me