table F has

key varchar(12)

x1 int, x2 int, x3 int, x4 int

Sample Data

key x1  x2  x3  x4

1    12  1    2   null

2    1    2   null  null

12   2   null  null  null

14   null null  null  null

Table D...

i am trying to avoid this approach since each table has about 500 columns ,, there gotta be some more automated way of doing this?