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 |
|
IC
Starting Member
1 Post |
 Posted - 2007-07-05 : 06:10:50
|
| I have temp table that contains one column. The data from the temp table must be exported to another table and then the data must be separated into 3 columns in another table.The data looks like this in the temp table that has one column:TEST01 - TEST SMS: Control Dates Failure on Jul 3 2007 8:10AM The columns names are supposed to be separated like this:ServerName - TEST01,Alert - TEST SMS: Control Dates Failure,Alert Date - Jul 3 2007 8:10AMthere should be now hyphens in the data.Can anyone perhaps help me with this? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-07-05 : 10:27:15
|
| You need to know what basis data should be speratedIf you have data like thisTEST01 - TEST SMS: Control Dates Failure on - Jul 3 2007 8:10AM (hyphen before jul)then you can make use of parsename function to split and store them in different columnsRead about it in sql server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Separating data into columns - DTS