Extracting Rows from Text Field

[jschodde]

I have a table that contains a unique key and a text field. The text fields contains part numbers of different lengths like:

key part_numbers
----- ------------
1 99
999
9999
2 99999
99
9999

Over time, the length of each part number could get longer.

With that in mind, I want to create a new RECORD for each part number like this:

key part_numbers
----- ------------
1 99
1 999
1 9999
2 99999
2 99
2 9999

Thanks,
Jeff

 

[dbomrrsm]

What detemines that the second and third rows are key 1 ?

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[jschodde]

The "key" field in that case would not be unique (my mistake).

What would determine the "key" field value?: If I were to write some kind of stored procedure, I envision looping through each row of the text field and inserting rows into a cursor or some other table.

I'm not sure a simple T-SQL statement could be used in this case.

Jeff