merging rows

[JackpipE]

hello,

I'm moving to new e-commerce platform and I need to modify the way I
store my products.
My current layout for products in multiple category:
sku|category_id
V82|1
V82|2
V82|3

New layout:
sku|category_id
V82|1,2,3

Is there any way to make the transition in SQL? I have it all in
Access but I'm not VB guy and if possible would like to do it in SQL
if it's possible.

Thanks,
JP

[Tom van Stiphout]

On Tue, 15 Jan 2008 19:38:20 -0800 (PST), JackpipE
<pi*******@gmail.comwrote:

That sounds like a really bad idea to denormalize the data like that.
Perhaps you would consider leaving the design in place, and use a
special query in those few instances where you want the data output
that way. Here is an article that may help with that:
http://www.mvps.org/access/modules/mdl0004.htm

-Tom.

>hello,

I'm moving to new e-commerce platform and I need to modify the way I
store my products.
My current layout for products in multiple category:
sku|category_id
V82|1
V82|2
V82|3

New layout:
sku|category_id
V82|1,2,3

Is there any way to make the transition in SQL? I have it all in
Access but I'm not VB guy and if possible would like to do it in SQL
if it's possible.

Thanks,
JP

[lyle]

On Jan 15, 10:38 pm, JackpipE <[e-mail]:

hello,

I'm moving to new e-commerce platform and I need to modify the way I
store my products.
My current layout for products in multiple category:
sku|category_id
V82|1
V82|2
V82|3

New layout:
sku|category_id
V82|1,2,3

Is there any way to make the transition in SQL? I have it all in
Access but I'm not VB guy and if possible would like to do it in SQL
if it's possible.

Thanks,
JP

Why not just slit your wrists or drink poison?

[Tom van Stiphout]

On Tue, 15 Jan 2008 22:04:12 -0800 (PST), lyle
<ly************@gmail.comwrote:

Why don't you tell us how you really feel?
I understand they have long winters up there in .ca

-Tom.

<clip>

>
Why not just slit your wrists or drink poison?