Hi.
I'm confuse on how I will create my temporary table.
Need some clarification here.

I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns.

ammm... how will I do this?

Is it better to create my table were first at hand I will define the columns it needs and just update it or let the select statement define its columns which means I need to alter the temporary table to add the new column?