quote:

---

Originally posted by ConradK

Okay, so here is the constraints of the challenge.

I have table A and table B.

Every row in table A must become a column in table B.

Table A is this

addme

a
b
c
d

and table B is this:

e,f,g,h
1,1,1,1


I need to update table B to reflect table A in the following way

a,b,c,d,e,f,g,h
null,null,null,null,1,1,1,1

See whats happening here?

I have a list of 'columns' in table A that need to be added in a secondary table, that needs to be turned around and added to table B.



I'm coming up with some ways on my own, but wondering what you may be thinking.

Table A and B are infinitly subject to change, but for certain, the values in table A are not already a part of column B.

Good Luck!

---