VegasL (12/23/2012)

---

pink skirt for boys

VegasL (12/23/2012)

---

Hi John,

Yes I agree something wrong with that. I'm working with large data set, didn't even notice.

Anyways, I did read the link you posted on forum etiqutte so hopefully I am complying now.

I put the data in .xls format for ease of use. Hopefully thats what you're were asking for.

Yes, coded answer would be appreciated.

Thanks

I'm trying to combine all 3 columns as 'combined kw'

create table #temp23(color nvarchar(566),item nvarchar(455),size nvarchar(332))
insert into #temp23
select 'red','shirt','for women' union all
select 'green','jumper','for men' union all
select 'yellow','blouse','for girls' union all
select 'black','coat','extra large' union all
select 'blue green','t-shirt','for boys' union all
select 'pink','skirt','one size fits all'
select * from #temp23


create table #t(a nvarchar(566))
insert into #t select color from #temp23
create table #t1(b nvarchar(566))
insert into #t1 select item from #temp23
create table #t2(c nvarchar(566))
insert into #t2 select size from #temp23
select *,(a+' '+ b+' '+c) as total from #t cross join #t1 cross join #t2

VegasL (12/23/2012)

---

Hello,

I have several columns, such as:

Coulmn A

red
green
yellow
black
blue green
pink

Column B

shirt
jumper
blouse
coat
t-shirt
skirt

Column C

for women
for men
for girls
extra large
for boys
one size fits all



I need to permutate, it such a way that gives me the following result:

red shirt for women
red shirt for men
red shirt for girls
red shirt extra large
red shirt for boys
red shirt one size fits all
red jumper for women
red jumper for men
...
pink skirt for boys
pink skirt one size fits all


I was able to put each column in 3 separate tables, and then do a simple cross join but would like to have all the columns in one table and then the result.

Thanks