Hi deepuv04,
Thank you very much! This code really helped me to solve my "color" problem!
siofok
Last Activity: Apr 29 '08, 01:29 PM
Joined: Apr 25 '08
Location:
-
Great!
This gives the result i was looking for.
I have one question left.
How do I insert this result in the color table itself?
The original colors are in the color column (blue - green - white).
I would like each separated color inserted into the columns color1 color2....
Thank you very much!Leave a comment:
-
Hi, thank you for your reply!
I tried it, and this works,
but when i set the @colurs to the table column, it only returns one result.
I have a whole table with rows containing colors.
like row 1: blue - white - yellow
row 2: brown - white
row 3: red - blue - white - orange - brown
i have a solution that works for only two values, seperated by a ,:
...Code:Leave a comment:
-
split color values into multiple records in sql server 2005
Hi,
I have a table with color values. All these values differ from 1 color to 5 colors.
I.e.
brown - white - yellow -purple - blue
white - yellow
green
etc.
Now I want to seperate these values into different columns.
So insert the seperate color values into color1,color2,c olor3, color4, color5
I am a newbee, so please can someone show me the code for this...
No activity results to display
Leave a comment: