SQLTeam.com | Weblogs | Forums

How to create multiple records based off a comma delimited column


#1

How do I code to pull from a table that looks like this

|Topic_MEASURE_| CODING _SYSTEM| CODE | MODIFIER | PLACE _OF _SERVICE|
| 1 | CPT_II | 3046F | 8P, ≠ 1P, 2P, 3P | NULL |

to return this

|Topic_MEASURE_| CODING _SYSTEM| CODE | MODIFIER | PLACE _OF _SERVICE|
| 1 | CPT_II | 3046F | 8P | NULL |
| 1 | CPT_II | 3046F | 1P | NULL |
| 1 | CPT_II | 3046F | 2P | NULL |
| 1 | CPT_II | 3046F | 3P | NULL |

image


#2

please create sample dml & ddl for us to use to help us help you?


#3

see http://www.sqlservercentral.com/articles/Tally+Table/72993/