merging rows

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

Re: merging rows

On Tue, 15 Jan 2008 19:38:20 -0800 (PST), JackpipE
wrote:

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

Re: merging rows

On Jan 15, 10:38 pm, JackpipE wrote:
> 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?

Re: merging rows

On Tue, 15 Jan 2008 22:04:12 -0800 (PST), lyle
wrote:

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

-Tom.


>
>Why not just slit your wrists or drink poison?