Multiple Words in 1 record splitted 1

[michaela18]

I have a field called Phonecodes and it would show what phones people brought, but it will show all the phones. So the field look something like this:

Phonecodes
Samsung Motorola Apple

It's sepparated by spaces.

I have a query that pulls up the date, phonecode, keyID, and Pricecode


Is there a way to duplicate a row so say if a row has

Phonecodes
Samsung Motorola Apple

then it will be 3 rows instead, each with the same date, keyID, and Pricecode but with the phonecodes split out?

 

[markros]

Yes, you need a split function.

Take a look here

http://social.msdn.microsoft.com/Fo...eb5ba52/#d7811e25-4670-4dae-afd5-d9ed61da2e93

PluralSight Learning Library

 

[JoeAtWork]

Any reason why the data is unnormalized in the first place?

The proper way to do it is to store those 3 values in separate records of a related table.