Re: How to break the words

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 09:28:23 -0500

This question should be posted in the Microsoft.public.sqlserver.programming
newsgroup 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pro" <nospam@nospam.net> wrote in message
news:OR%23hNpiGFHA.3612@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I have a table which data is organized as follows,
>
> Style                        Color  Size_Qty
> MEW6SQ215        101     XS,12; S,12; M,10;
> MZ10E727L           360     29,2;30,4;31,6;32,4;33,2;
> M002U2402           387     S,34; M,54; L,35;XL,17;
> M002D6502           100     XS,137; S,502; M,499; L,212;
>
> How can I using a query to form the record as following
> Style                        Color  Size    Qty
> MEW6SQ215        101     XS       12
> MEW6SQ215        101        S       12
> MEW6SQ215        101        M       10
> MZ10E727L           360       29        2
> MZ10E727L           360       30        4
> .
> .
> .
> .
>
> Thank you.
>
>
>

Relevant Pages