I am in the new cursor from hell sp. I have to dynamically take our oracle data and recreate it by denormalized input form in our reporting/ data mart SQL Server environment.

I have Meta data that makes our java input screens. I know the Text and the data location for each entry form in that screen. Outside of the keys for defining who and what event this is, how would you dynamically create an "N" column form for each data entry field.

A screen to me is a series of questions (TEXT) and answers (Data). I have to devise a table to hold each answer A5, A6, A7.... AN.

I am thinking of of creating the columns info into a #Temp table and then loading that into a cursor to write the script to create that table. Is there another method to look to of is this the down and dirty way to success?

# of tables to be created in this process, 150+

Oh yeah, I then have to poplulate them with data but that's another day!

__Stephen