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 |
|
harsh.dhawan
Starting Member
10 Posts |
 Posted - 2008-07-08 : 01:48:28
|
| Hi AllI have a query regarding bulk insert, I have one txt file which contains Date and Time field speprated with #. I want to insert these two fields in single column by concating the value. Also i need to calculate the the value of one more field from the value of one column in txt file.How can i do this?Cheers Harsh Dhawan |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-08 : 01:53:53
|
what is the delimiter ? # or something else ?Depending on what is the delimiter, insert into one or two string columns in staging table and then use convert() to convert into datetime in your final destination table.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Query regarding BULK INSERT