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 |
|
jrepanich
Starting Member
1 Post |
 Posted - 2006-01-20 : 13:31:04
|
| I am attempting to split a table using a view.my table BGTMRG contains the following fields:entityYearacctsubacctamountThe amount field contains 12 months of data seperated by ';'Data Example:The data looks like...enity year acct subacct amountentity1 2005 1000 b '10;20;10;10;10;10;15;20;10;10;50;10'I want this data in view that looks like:enity year acct subacct 01 02 03 04 05 06 07 08 09 10 11 12entity1 2005 1000 b 10 20 10 10 10 10 15 20 10 10 50 10 |
|
|
sureshot
Yak Posting Veteran
72 Posts |
Posted - 2006-01-20 : 14:09:02
|
| Have a look here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648 |
 |
|
|
|
|
|
fn_split... maybe?